<!--- 
 Filename: MerchRecordsetProvider.cfm
 Author: Nate Weiss (NMW)
 Purpose: Provides data to a Flash MX movie
--->

<!--- Query the database for merchandise records --->
<cfquery name="merchQuery" datasource="#APPLICATION.dataSource#">
 SELECT MerchID, MerchName
 FROM Merchandise
 ORDER BY MerchName
</cfquery>

<!--- This will be available as the “result” variable in the --->
<!--- MerchRecordsetProvider_Result handler within the Flash movie --->
<cfset FLASH.result = merchQuery>
