Most databases have tables that store table metadata
like SQL Server has sysobjects
Informix has systables, syscolumns
You can query these tables to get the information you are after.
What Database Server are you using?
On 5/3/07, 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:
> www.WebsiteSolutions.com.au <http://www.websitesolutions.com.au/>
> www.AustralianAccommodation.com <http://www.australianaccommodation.com/>
> www.AccommodationNewZealand.com <http://www.accommodationnewzealand.com/>
> www.HospitalityPurchasing.net <http://www.hospitalitypurchasing.net/>
> www.Samaris.net <http://www.samaris.net/>
>
>
> >
>
--
If you are not living on the edge,
You are taking up too much space.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
