Actually I would add TOP 1 to the select statement that way you are not obtaining All records in a LARGE table.
-----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Saturday, October 07, 2006 5: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:255898 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
