<!---
Name:        tree.cfm
Author:      Ben Forta (ben@forta.com)
Description: Flash tree example
Created:     12/22/04
--->

<!--- Get movies by rating --->
<cfquery datasource="ows" name="movies">
SELECT Rating, MovieTitle, FilmID
FROM Films, FilmsRatings
WHERE Films.RatingID = FilmsRatings.RatingID
ORDER BY Rating, MovieTitle
</cfquery>

<cfform format="flash">

<!--- Define tree control --->
<cftree name="treeMovie"
        height="400"
        width="500">
 <!--- Specify tree data --->
 <cftreeitem query="Movies"
             value="Rating,FilmID"
             display="Rating,MovieTitle">
</cftree>

</cfform>
