House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home / Groups / ColdFusion Talk (CF-Talk)

Get Query Column Names

Author:
Arsalan Tariq Keen
07/11/2009 02:43 PM

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


Search cf-talk

February 04, 2012

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
       1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29