Oh, right. Or if he's just trying to address one row in a query result set, he'd need something like this for row 35:
<cfset thiscurrentrecord = 35> <cfloop from="1" to="#myQuery.NUM_CART_ITEMS[thiscurrentrecord]#" index="cartentry"> #myQuery.["ITEM_NAME" & cartentry][thiscurrentrecord]#<br> </cfloop> ...and, of course, if myQuery.["ITEM_NAME" & cartentry] is coming out of the database, that database is *not* in 3rd normal. :-) On Tue, Sep 1, 2009 at 9:06 PM, Jason Fisher <ja...@wanax.com> wrote: > > currentRecord is a property of a query, not a query itself and you don't > need it to loop over a query = use the cfoutput syntax to loop over your > query: > > <cfoutput query="myQuery"> > #item_name#<br /> > </cfoutput> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4