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@hotmail.com> 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
>
>
