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

<!--- Get movie list from database --->
<CFQUERY NAME="movies" DATASOURCE="ows">
SELECT MovieTitle, PitchText, Summary, DateInTheaters
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>

<!--- Display movie list --->
<TABLE>
<TR>
 <TH COLSPAN="2"><FONT SIZE="+3">Movie List</FONT></TH>
</TR>
<CFOUTPUT QUERY="movies">
<TR>
 <TD>
  <FONT SIZE="+2"><B>#MovieTitle#</B></FONT><BR>
  <FONT SIZE="+1"><I>#PitchText#</I></FONT>
 </TD>
 <TD>Released: #DateFormat(DateInTheaters)#</TD>
</TR>
<TR>
 <TD COLSPAN="2">#Summary#</TD>
</TR>
</CFOUTPUT>
</TABLE>

</BODY>
</HTML>

