Here's one way: <CFQUERY Name="GetData" ... > select * from table where 1 = 0 </CFQUERY>
(Use WHERE 1 = 0 so you get no records, but the ColumnList variable will still be populated.) <CFLOOP LIST="#GetData.ColumnList#" INDEX="Column"> #Column# </CFLOOP> Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -----Original Message----- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 3: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 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
