<!---
Name:        frame_movies.cfm
Author:      Ben Forta (ben@forta.com)
Description: Left frame for data drill-down
Created:     12/15/04
--->

<!--- Get movie list from database --->
<cfquery name="movies" datasource="ows">
SELECT FilmID, MovieTitle
FROM Films 
ORDER BY MovieTitle
</cfquery>

<body>

<!--- title and movie count --->
<cfoutput>
<strong>
Movie List (#Movies.RecordCount# movies)
</strong>
</cfoutput>

<!--- Movie list --->
<ul>
 <cfoutput query="movies">
 <li><a href="frame_details.cfm?filmid=#URLEncodedFormat(Trim(FilmID))#" target="right">#MovieTitle#</a>
 </cfoutput>
</ul>

</body>
