There was an article in the ColdFusion Developer's Journal called Dynamic
Table & Query Engine that gives you what you need, and then some (provided
you're NOT using Access). I couldn't find the complete article on line, but
you can get the source code listings at http://www.sys-con.com/coldfusion/.
Click on SOURCE CODE in the header, select volume 1, Issue 6, and select
Dynamic Table & Query Engine.
Marianne Daye
Programmer/Analyst
Information Delivery Systems
http://ids.rti.org
-----Original Message-----
From: Nille af Ekenstam [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 17, 2000 8:56 AM
To: [EMAIL PROTECTED]
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.
