I would add "WHERE 1=0" just so no records are returned. M!ke
-----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Saturday, October 07, 2006 4:14 PM To: CF-Talk Subject: Re: Output list of fields names from table Les Mizzell wrote: > What's the quickest dirtiest way (for testing only) to output all the > field names from a specific table - assuming you've *no* idea what the > field names are to start with and can only get at the table (for the > moment) through a query on a CF page? > <cfquery name="thequery"...>SELECT * FROM sometable</cfquery> <cfoutput>#thequery.columnlist#</cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
