<CFQUERY NAME="GetResults" DATASOURCE="ows">
  SELECT MerchID, MerchDescription
  FROM Merchandise
  WHERE (0=0
  <CFLOOP LIST="#Form.Criteria#" INDEX="ThisWord" DELIMITERS=" ">
    AND (MerchDescription LIKE '%#ThisWord#%')
  </CFLOOP>)
</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>
