If you want them all to be accessible individually, you can build
them all out as an array of associative arrays:
<!--- Fake query --->
<cfset myQuery = queryNew("contactId,firstname,lastname") />
<cfset queryAddRow(myQuery) />
<cfset querySetCell(myQuery, "contactId", 1, 1) />
<cfset querySetCell(myQuery, "firstname", "Jimi", 1) />
<cfset querySetCell(myQuery, "lastname", "Hendrix", 1) />
<cfset queryAddRow(myQuery) />
<cfset querySetCell(myQuery, "contactId", 2, 2) />
<cfset querySetCell(myQuery, "firstname", "Joe", 2) />
<cfset querySetCell(myQuery, "lastname", "Satriani", 2) />
<!--- Output as JS array --->
<cfoutput>
<script>
var guitarPlayers = [];
<cfloop query="myQuery">
<cfsilent>
<cfset player = "{" />
<cfloop list="#myQuery.columnList#" index="column">
<cfset player = player & lCase(column) & ":""" &
myQuery[column]
[myQuery.currentRow] & """" />
<cfif column neq listLast(myQuery.columnList)>
<cfset player = player & "," />
</cfif>
</cfloop>
<cfset player = player & "}" />
</cfsilent>
guitarPlayers[guitarPlayers.length] = #player#;
</cfloop>
alert(guitarPlayers);
alert(guitarPlayers[0].firstname);
</script>
</cfoutput>
You can also use <cfwddx> to automatically change the query into a JS
variable.
-Joe
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2685
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
