I have the code doing what i need it to do.
<script type="text/javascript" language="JavaScript">
auto = new Array();
<CFOUTPUT>
<CFSET i = 1>
<CFLOOP QUERY="newauto">
auto[#i#] =
('#newauto.color#','#newauto.price#','#newauto.mileage#','#newauto.vin#');
<CFSET i = i + 1>
</CFLOOP>
</CFOUTPUT>
</script>
Now how do i output the results.
AND is there a way to do a 'next n'with such an array?
>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
>
>
>On Apr 5, 2007, at 5:15 AM, Adrian Lynch wrote:
>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2686
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
