Don't forget you have access to testquery.columnlist which is a comma delimited list of all the columns in the current query object.
testquery["columnname"][row] ~Todd At 10:29 AM 1/15/2003 -0500, you wrote: >I figured the answer would be similar. In my actual use I need to loop over >a query without knowing what the columns are, so I use the >recordset.columnlist in my list loop. That's why I created the structure >with testquery[i], so I could approximate query["foo"]. > >So if I say testquery[1], don't I still need to supply the columnname >somehow to get at the values? Would that be testquery[1].foo? If it is, >how would I approximate that without knowing what "foo" actually is at >runtime? > >-Patti ---------- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ http://www.devmx.com/ ---------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
