Thanks Scott... I was using the query.ColumnList as function instead of
variable/list :)

thanks man!

Regards,
Arsalan

--------------------------------------------------
From: "Arsalan Tariq Keen" <arsalkeen@...>
Sent: Sunday, July 12, 2009 12:42 AM
To: "cf-talk" <cf-talk@...>
Subject: Re: Get Query Column Names

>
> 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:324444