You could try: <cfquery name="qInfo" datasource... etc> SELECT * FROM [table name] WHER 1 = 2 </cfquery>
<p>list of Columns</p> <cfoutput>#qInfo.columnList#</cfoutput> <p>Information about columns</a> <cfdump var="#getMetaData(qInfo)#"> Stephen M wrote: > That would be query_name.columnList which gives you a comma- > delimited list of the query columns. > > Stephen > > On May 3, 6:57 am, "claude raiola" <[EMAIL PROTECTED]> wrote: > > Just wondering if its possible to dynamically read column names of an > > existing sq table. > > > > What I am trying to create is a facility where the user can select the table > > name which will then list the columns of the given table. > > > > The user can the select the column names of choice which will in turn be > > used to build in a CF Query > > > > I look forward to your comments > > > > Kind Regards > > > > Claude Raiola > > B.Econ(Acc.); B.Hotel Mngt. > > Mobile: 0414 228 948 > > Phone: 07 5527 1990 > > Fax: 07 3319 6444 > > > > Websites: > > <http://www.websitesolutions.com.au/>www.WebsiteSolutions.com.au > > <http://www.australianaccommodation.com/>www.AustralianAccommodation.com > > <http://www.accommodationnewzealand.com/>www.AccommodationNewZealand.com > > <http://www.hospitalitypurchasing.net/>www.HospitalityPurchasing.net > > <http://www.samaris.net/>www.Samaris.net --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
