You will probably need to use array notation: temp["B&M"][currentRow]
or to show the dynamic-ness: cfset columnName = "B&M" temp[columnName][currentRow] Think of it is a two-dimensional array if you will. ~Brad -------- Original Message -------- Subject: Referencing column names in queries with special characters From: Doug Ford <[email protected]> Date: Mon, March 22, 2010 3:55 pm To: cf-talk <[email protected]> Hi folks - I am looking for help trying to access a column name within a query that has special characters in it: /, &, \ Here's a simple example: cfquery datasource="test" name="temp" Select [B&M], test from test /cfquery cfoutput query="temp" #[B&M]# <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:332027 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
