You misread him. Do it exactly as he showed: <cfoutput>#yourquery.columnlist#</cfoutput>
It isn't a function, but rather a property of the query itself. No (). On Sat, Jul 11, 2009 at 1:42 PM, Arsalan Tariq Keen<[email protected]> wrote: > > Hey Scott.... > this function query.ColumnList() is not documented in CF8 ... is it? > I am asking this because its not working with me :( > > -------------------------------------------------- > From: "Scott Stroz" <[email protected]> > Sent: Sunday, July 12, 2009 12:38 AM > To: "cf-talk" <[email protected]> > Subject: Re: Get Query Column Names > >> >> Yep, you you are looking for queryName.columnlist. >> >> So if your query looks like this: >> >> <cfquery name="myTest" datasource="myDB"> >> SELECT * FROM xyz >> </cfquery> >> >> You can get the list of columns by looking at myTest.columnList. >> >> >> On Sat, Jul 11, 2009 at 2:25 PM, Arsalan Tariq >> Keen<[email protected]> wrote: >>> >>> Hi friends... >>> >>> Is there any way in CF8 with which I can get the list of column names my >>> database query returns. >>> >>> For example I am using a query: >>> >>> SELECT * FROM xyz >>> >>> Is there any way to know which columns are returned?? >>> >>> >>> Regards, >>> Arsalan >>> >>> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:324447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
