one method, which would avoid system tables, or other vendor specific methods, would be to simply do a "Select * From Table" using CFQUERY, then using the ColumnList field in the result list - it's a comma delimited list of all the columns.
On SQL Server you can query the system tables (I think it's sysobjects you want here). I'm not sure about the system tables or methods available to Oracle or MySQL. Hope that helps. Shawn Grover -----Original Message----- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 1:15 PM To: CF-Talk Subject: Querying a table for its columns Querying a table for its columns I can't remember the syntax for querying a table for its columns. I think it is a mySQL table on CF 4.0x box. Eric ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
