<!---
Name:        movies3.cfm
Author:      Ben Forta (ben@forta.com)
Description: Data-driven HTML list
Created:     4/1/01
--->

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

<!--- Create HTML page --->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
    <TITLE>Orange Whip Studios - Movie List</TITLE>
</HEAD>

<BODY>

<H1>Movie List</H1>

<!--- Display movie list --->
<UL>
<CFOUTPUT QUERY="movies">
<LI><B>#MovieTitle#</B> - #PitchText#</LI>
</CFOUTPUT>
</UL>

</BODY>
</HTML>

