So how would I write the cfoutput statement to list the tables if I don't
know what they are? I just want the table names
----- Original Message -----
From: "Mario Talavera" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 2:16 PM
Subject: RE: How to get a list of all tables in a given datasource - and h
ow to combine queries
> SELECT * FROM tab;
>
> ....will give you all the table availables for you in oracle
>
>
> Mario Talavera
> Developer
> http://www.joepix.com
>
>
>
>
> -----Original Message-----
> From: Jim Watkins [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 08, 2001 10:18 AM
> To: CF-Talk
> Subject: Re: How to get a list of all tables in a given datasource - and
> how to combine queries
>
>
> Does anyone have the code to get a list of Tables from an Oracle
database?
>
>
> ----- Original Message -----
> From: "Diana Nichols" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, June 08, 2001 9:08 AM
> Subject: RE: How to get a list of all tables in a given datasource - and
how
> to combine queries
>
>
> > This will give you a list of the tables within a SQL database:
> >
> > <cfquery name=getTables datasource=#dsn#>
> > select table_name from information_schema.tables
> > </cfquery>
> >
> > <cfoutput query=getTables>
> > #table_name#
> > </cfquery>
> >
> > You should then be able to combine the data from both queries in
whatever
> > way you want.
> >
> > HTH
> > D
> > *************
> > Diana Nichols
> > Webmistress
> > http://www.lavenderthreads.com
> > 770.434.7374
> >
> > "One man's magic is another man's engineering." ---Lazarus Long
> >
> >
> > -----Original Message-----
> > From: JoshMEagle [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, June 08, 2001 8:34 AM
> > To: CF-Talk
> > Subject: How to get a list of all tables in a given datasource - and how
> > to combine queries
> >
> >
> > Have two questions ....
> >
> > First, given the name of a datasource, how do I go about finding what
> tables
> > are contained in the datasource via CF (not just opening SQL Server)
> >
> > Second, I have a query of all the datasources on my server using
> > <cfregistry> that is returned as a query ... how can I combine this
> > information with the query to display the tables into one query? Is this
> > even possible?
> >
> > THANKS!
> >
> > Joshua Miller
> > Web Development
> > Eagle Technologies Group
> > Technology Solutions for the Next Generation
> > www.eagletgi.com
> > [EMAIL PROTECTED]
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
