<!---
Name:        ratings_graph1.cfm
Author:      David Golden (d_golden73@hotmail.com)
Description: First graph
Created:     4/15/01
--->

<!--- Get rating list from database --->
<CFQUERY NAME="GetRatings" DATASOURCE="ows">
  SELECT Rating, Count(*) AS FilmCount
  FROM FilmsRatings, Films
  WHERE FilmsRatings.RatingID = Films.RatingID
  GROUP BY Rating
  ORDER BY Rating
</CFQUERY>

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

<BODY>

<!--- Displays graph from query data --->
<CFGRAPH
  TYPE="Pie"
  QUERY="GetRatings"
  VALUECOLUMN="FilmCount"
  ITEMCOLUMN="Rating"
  FILEFORMAT="Flash">
</CFGRAPH>
  
</BODY>
</HTML>
