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

Search cf-talk

February 09, 2010

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

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


Mailing Lists