Hi Brad - 

Thank you very much for the assistance.  I was trying something similar to 
that, but just didn't have the right use of it!

Thanks for your help!

Doug

>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
>
>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:332033
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to