<!---
Name:        details2.cfm
Author:      Ben Forta (ben@forta.com)
Description: Data drill-down details with basic validation
Created:     4/1/01
--->

<!--- Make sure FilmID was passed --->
<CFIF NOT IsDefined("URL.FilmID")>
 <!--- It wasn't, send to movie list --->
 <CFLOCATION URL="movies6.cfm">
</CFIF>

<!--- Get a movie from database --->
<CFQUERY NAME="movie" DATASOURCE="ows">
SELECT FilmID, MovieTitle, PitchText,
       Summary, DateInTheaters, AmountBudgeted
FROM Films 
WHERE FilmID=#URL.FilmID#
</CFQUERY>

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

<BODY>

<!--- Display movie details --->
<CFOUTPUT QUERY="movie">
 <TABLE>
  <TR>
   <TD COLSPAN="2">
    <IMG SRC="../images/f#FilmID#.gif" ALT="#MovieTitle#" ALIGN="MIDDLE">
    <B>#MovieTitle#</B>
   </TD>
  </TR>
  <TR VALIGN="top">
   <TH ALIGN="right">Tag line:</TH>
   <TD>#PitchText#</TD>
  </TR>
  <TR VALIGN="top">
   <TH ALIGN="right">Summary:</TH>
   <TD>#Summary#</TD>
  </TR>
  <TR VALIGN="top">
   <TH ALIGN="right">Released:</TH>
   <TD>#DateFormat(DateInTheaters)#</TD>
  </TR>
  <TR VALIGN="top">
   <TH ALIGN="right">Budget:</TH>
   <TD>#DollarFormat(AmountBudgeted)#</TD>
  </TR>
 </TABLE>
</CFOUTPUT>

</BODY>
</HTML>

