<CFQUERY NAME="GetResults" DATASOURCE="ows">
  SELECT MerchID, MerchDescription
  FROM Merchandise
  WHERE (MerchDescription LIKE '%#Form.Criteria#%')
</CFQUERY>


<HTML>
<HEAD>
<TITLE>Search Results</TITLE>
</HEAD>

<BODY>

<H2><CFOUTPUT>
#GetResults.RecordCount# Merchandise record(s) found for "#Form.Criteria#".
</CFOUTPUT>
</H2>

<UL>
<CFOUTPUT QUERY="GetResults">
  <LI>#MerchDescription#
</CFOUTPUT>
</UL>

</BODY>

</HTML>
