> i want to retrieve the column names of the table using coldfusion. The
> database we r using is SQL server 7. i know how to get column names from
> query analyzer. but thru coldfusion is it possible to get them.
<CFQUERY DATASOURCE="#application.DataSource#" NAME="GetColumnNames">
SELECT *
FROM YourTable
</CFQUERY>
<CFOUTPUT>#GetColumnNames.ColumnList#</CFOUTPUT>
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.co.uk/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
