<!---
Name:        movies.cfm
Author:      Ben Forta (ben@forta.com)
Description: Left frame for data drill-down
Created:     4/1/01
--->

<!--- Get movie list from database --->
<CFQUERY NAME="movies" DATASOURCE="ows">
SELECT FilmID, MovieTitle
FROM Films 
ORDER BY MovieTitle
</CFQUERY>

<BODY>

<CFOUTPUT>
<B>Movie List (#Movies.RecordCount# movies)</B>
</CFOUTPUT>

<!--- Movie list --->
<UL>
 <CFOUTPUT QUERY="movies">
  <LI><A HREF="details.cfm?FilmID=#URLEncodedFormat(Trim(FilmID))#" TARGET="right">#MovieTitle#</A>
 </CFOUTPUT>
</UL>

</BODY>
