Coldfusion (CFM) - Searching A Product on our Category
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Advanced Search</title>
</head>
<body>
<h2>Advanced Search Form</h2>
<form method="post">
Enter keyword : <input type="text" name="keyword" /> <br />
<input type="submit" value="Search" name="Search" />
</form>
<cfif IsDefined(’FORM.Search’)>
<cfquery name = "qCateg" datasource="webfillers">
EXEC sp_get_category @keyword = ‘#FORM.keyword#%’
</cfquery>
<table>
<tr>
<td width="18" bgcolor="#0066FF"> </td>
<td width="138" bgcolor="#0066FF"><div align="center"><strong>PRODUCT CATEGORY ID</strong></div></td>
<td width="204" bgcolor="#0066FF"><div align="center"><strong>CATEGORY</strong></div></td>
<td width="279" bgcolor="#0066FF"><div align="center"><strong>DESCRIPTIONS</strong></div></td>
<td width="279" bgcolor="#0066FF"><div align="center"><strong>ACTION</strong></div></td>
</tr>
<cfset i = 1>
<cfloop query="qCateg">
<cfoutput>
<tr>
<td>#i#</td>
<td><div align="center">#qCateg.PRODUCTCATEGID#</div></td>
<td>#qCateg.CATEGORY#</td>
<td>#qCateg.DESCRIPTIONS#</td>
<td><a href="updatecategory.cfm?productcategID=#qCateg.PRODUCTCATEGID#">Update</a>
<a href="deletecategory.cfm?productcategID=#qCateg.PRODUCTCATEGID#">Delete</a></td>
</tr>
</cfoutput>
<cfset i = i + 1>
</cfloop>
</table>
</cfif>
</body>
</html>
