Try #test.ColumnList# Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com
-----Original Message----- From: Brian Fox [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 1:03 PM To: CF-Talk Subject: Select * From - any way to get field names? How can I list the fieldnames after using a query like <cfquery name="test">select * from table</cfquery>? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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

