<!---
Name:        dynamicsql.cfm
Author:      Ben Forta (ben@forta.com)
Description: Dynamic SQL demonstration
Created:     12/15/04
--->

<!--- Create FilmID variable --->
<cfset FilmID=1>

<!--- Get a movie from database --->
<cfquery name="movie"
         datasource="ows"
         result="results">
SELECT FilmID, MovieTitle, PitchText
FROM Films
WHERE FilmID=#FilmID#
</cfquery>

<h1>Display Data</h1>
<cfdump var="#movie#">
<h1>Display cfquery Results</h1>
<cfdump var="#results#">
