Jeff, Try:
Variables.myQuery[columnName][currentrow] -Mark -----Original Message----- From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: Friday, November 03, 2006 7:00 AM To: CF-Talk Subject: Syntax ... Dynamic Query Column Name I only use this syntax on rare occasions, so I can never remember it. I have a query that I am looping over. The loop does not know the columns in the query, so there is a inner loop inside that loops over the list of columns. The current column is stored in the index variable of the inner loop and I am trying to display the contents of the query cell. <cfloop query="variables.myQuery"> <cfloop list="variables.myQuery.columnList" index="columnName"> <cfoutput>#variables.myQuery.???columnName???#</cfoutput><br/> </cfloop> </cfloop> What is the correct syntax for the <cfoutput statement above? I know I can use evaluate, but I thought there was another array like syntax that could be used here that performed better than evaluate. Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259019 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
