<!---
Name:        generate_budget_graph.cfm
Author:      David Golden (d_golden73@hotmail.com)
Description: Budget Graph Action Page 
Created:     4/15/01
--->

<CFOUTPUT>

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

<CFQUERY NAME="GetBudgets" DATASOURCE="ows">
  SELECT FilmID, MovieTitle, AmountBudgeted
  FROM Films
  WHERE AmountBudgeted > #Form.MinBudget#
</CFQUERY>

<!--- Set variables to URL variables --->

		
<!--- Create HTML page --->

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

<html>
<head>
	<title>Interactive Budget Graph - Orange Whip Studios</title>
</head>

<body>

<!--- Displays graph from query data --->

<CFGRAPH
	TYPE="#Form.GraphType#"
	BACKGROUNDCOLOR="#Form.BGColor#"
	QUERY="GetBudgets"
  	VALUECOLUMN="AmountBudgeted"
  	ITEMCOLUMN="MovieTitle"
  	FILEFORMAT="FLASH"
	TITLE="#Form.GraphName#"
	Depth="10"
	URL="budget_details.cfm?FilmID="
	URLCOLUMN="FilmID"
	SHOWVALUELABEL="Rollover">
</CFGRAPH>

</CFOUTPUT>

</body>
</html>
