tycoon
06-07-2005, 03:34 PM
Hi all..what i'm trying to a simple search function....there prolem is my result page(testsearch2.cfm) won't
display the result at all...well here my code..can anybody please comment
first page(testsearch1.cfm)
<html>
<head>
</head>
<body>
<form name="form1" method="post" action="testsearch2.cfm">
Search on
<select name="fieldname" id="fieldname">
<option value="full_name" selected>Employee Name</option>
<option value="emp_no">Employee No</option>
</select>
for
<input name="sitem" type="text" id="sitem">
<input type="submit" name="Submit" value="Submit">
</form>
</body>
</html>
second or result page(testsearch2.cfm)
<html>
<head>
<cfquery name="result" datasource="epa">
Select * from employee where "#Form.fieldname#"="#Form.sitem#"
</cfquery>
</head>
<body>
<cfoutput>#result.emp_no#</cfoutput>
</body>
</html>
display the result at all...well here my code..can anybody please comment
first page(testsearch1.cfm)
<html>
<head>
</head>
<body>
<form name="form1" method="post" action="testsearch2.cfm">
Search on
<select name="fieldname" id="fieldname">
<option value="full_name" selected>Employee Name</option>
<option value="emp_no">Employee No</option>
</select>
for
<input name="sitem" type="text" id="sitem">
<input type="submit" name="Submit" value="Submit">
</form>
</body>
</html>
second or result page(testsearch2.cfm)
<html>
<head>
<cfquery name="result" datasource="epa">
Select * from employee where "#Form.fieldname#"="#Form.sitem#"
</cfquery>
</head>
<body>
<cfoutput>#result.emp_no#</cfoutput>
</body>
</html>