Ouch - sorry - didn't scroll down enough to see your response. Sorry! On Sun, Jul 12, 2009 at 1:13 PM, Raymond Camden<[email protected]> wrote: > 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:324448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
