Get Query Column Names

Thanks Scott... I was using the query.ColumnList as function instead of variable/list :) thanks man! Regards, Arsalan > Hey Scott.... > this function query.ColumnList() is not documented in CF8 ... is it? > I am asking this because its not working with me :( > >> 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 >>> >>> >> >> > >