Jerry
I asked this question myself and this is what I ended up with,
don't know if its the best but it may help you as well
<CFQUERY name="Qquery1">
Select *
From tbltable;
</CFQUERY>
<CFSET ColumnNamelist = #Qquery1.Columnlist#>
Then I could us this list later to loop through as needed.
-----Original Message-----
From: Jerry Staple [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 8:40 AM
To: CF-Talk
Subject: Output Field Names
Hi,
Does anyone know if there is anyway that you can output the Field
names (Column Names) for a specific table in a <cfquery>?(using access
db).
Jerry Staple
Web Applications Developer
BizNet Solutions
133 - 137 Lisburn Rd
Belfast
BT9 7AG
Tel: +44 (0)28 9022 3224
Fax: +44 (0)28 9022 3223
www.biznet-solutions.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
