You can use array notation to reference columns with spaces. So, instead of
myQuery.column with space use myQuery["column with space"][myQuery.currentRow] On Thu, Aug 29, 2013 at 10:09 AM, DURETTE, STEVEN J <[email protected]> wrote: > > Try looking at query_name.columnList it should have a list of the columns > returned from a cfquery. > > Of course replace query_name with the name of your actual query. > > -----Original Message----- > From: Monique Boea [mailto:[email protected]] > Sent: Thursday, August 29, 2013 11:08 AM > To: cf-talk > Subject: Re: Outputting SQL aliases as table headers > > > They are dynamic with spaces. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356655 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
