<CFQUERY NAME="GetFilms" DATASOURCE="ows">
   SELECT FilmID, MovieTitle
   FROM Films
</CFQUERY>

<HTML>
<HEAD>
<TITLE>Merchandise Search</TITLE>
</HEAD>

<BODY>

<H2>Please enter keywords to search for.</H2>

<FORM ACTION="MerchandiseSearch_Action6.cfm" METHOD="POST">
Keywords: <INPUT TYPE="text" NAME="Criteria"><BR>
<P>Film:<BR>
<SELECT SIZE="4" NAME="FilmID">
<CFOUTPUT QUERY="GetFilms"><OPTION VALUE="#FilmID#">#MovieTitle#
</CFOUTPUT>
</SELECT>
<P><INPUT TYPE="submit" VALUE="Search">
</FORM>

</BODY>
</HTML>
