<!---
Name:        budget_details.cfm
Author:      David Golden (d_golden73@hotmail.com)
Description: Budget details page
Created:     4/15/01
--->


<!--- Get title and budget information from database --->

<CFQUERY NAME="GetBudgets" DATASOURCE="ows">
  SELECT FilmID, MovieTitle, AmountBudgeted, DateInTheaters, RatingID
  FROM Films
  WHERE AmountBudgeted > 0
  AND FilmID = #URL.FilmID#
</CFQUERY>

<!--- Creates HTML page --->

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
	<title>Budget Details - Orange Whip Studios</title>
</head>

<body>

<!--- Displays movie title and budget in table --->

<H1><CFOUTPUT>#GetBudgets.MovieTitle# Budget Details</CFOUTPUT></H1>

<TABLE BORDER="1">
<TR>
 <TH>Movie Title</TH>
 <TH>Amount Budgeted</TH>
 <TH>Date in Theaters</TH>
 <TH>Ratings ID</TH>
</TR>
<CFOUTPUT QUERY="GetBudgets">
<TR> 
 <TD>#GetBudgets.MovieTitle#</TD>
 <TD>#GetBudgets.AmountBudgeted#</TD>
 <TD>#GetBudgets.DateInTheaters#</TD>
 <TD>#GetBudgets.RatingID#</TD>
</TR>
</CFOUTPUT>
</TABLE>


</body>
</html>
