But if you really like treating recordsets like arrays, you can:
<cfloop index="row" from="1" to="#query.recordCount#" step="1">
<cfoutput>#query['fieldname'][row]#</cfoutput><br>
</cfloop>
Some other things to note:
To get the list of fields returned in a query (recordSet), use query.columnList.
And you cannot directly set the value of a query field
<cfset query.fieldname=2>
You need to use the query functions like
<cfset tmp=QuerySetCell(query, fieldname, value [, row])>
(the [ ] above means an option parameter)
The var tmp will contain TRUE in the example above.
Hopefully some of this will be useful,
Jerry Johnson
>>> [EMAIL PROTECTED] 01/13/03 04:22PM >>>
<snip>
>You don't really need to put them into an array to loop over the
>recordset.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
