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<arsalk...@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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:324442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4