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" <boyzoid@...>
Sent: Sunday, July 12, 2009 12:38 AM
To: "cf-talk" <cf-talk@...>
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<arsalkeen@...> 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:324443