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 cfaussie@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---