oh yeah. god forbid the table has 10,000 and more records in it. The query would take a while. Goto groups.google.com and do a search there. I have seen this posted for Access, mssql, and mysql before.
Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -----Original Message----- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 3:41 PM To: CF-Talk Subject: RE: Querying a table for its columns 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists