<table>
<cfloop list="#myQuery.columnlist#" index="fieldname">
<tr>
<cfoutput>
<td>#fieldname#</td>
<td>#evaluate("myQuery.#fieldname#")#</td>
</cfoutput>
</tr>
</cfloop>
</table>
Dan
-----Original Message-----
From: Nille af Ekenstam
To: [EMAIL PROTECTED]
Sent: 7/17/2000 5:55 AM
Subject: Listing column names in a table
Hi
Anybody know of a good way to find out the column names in a database
table
and outputing them using CF?
What I want to achieve is to use all columns in a table to construct
some
variiables (columnname = value) with without having to know exactly how
many there are or what they are called.
Thanks!
//Nille
------------------------------------------------------------------------
------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
