[CFTALKTor] SQL - Returning Column Names

[Nolan J. Dubeau]

Hi All,   This is part question, and part thank you.  First off, thanks to everyone last week for the tips on activating the SQL server db.  I eventually got it to verify after setting up the ODBC source with the proper username, password permissions.   Second… Q:  (this may be basic to most)   I’m looking to run a query in my application.cfm file which will return the column names of a particular table in the db. I then want to return the column name results as a comma separated list, and set is as an application variable.  The var will then replace the fieldlist below:     <CFCASE value="newListing"> <cfmodule template="display/dsp_listingForm.cfm" action="BLANK" fieldlist="MLS,SectorCode,PropertyType,Bedrooms,Name,Address1,Address2,City,ProvinceState,PostalCode,Country,Description,Price,Image,VR,Map,Sold"></CFCASE>     So, my question is…. How do I write my SQL command to list only the column names?    Many Thanks.   Nolan     Nolan J. Dubeau Senior Developer (*.Maracca) Interactive.Print.Broadcast Design p. 416 532 8852 www.maracca.com