I've never combined queries before ... that was my second question ... how
do I return the results of both queries into one query?
Thanks for the code though, works beautifully
Joshua Miller
Web Development
Eagle Technologies Group
Technology Solutions for the Next Generation
www.eagletgi.com
[EMAIL PROTECTED]
-----Original Message-----
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 9:08 AM
To: CF-Talk
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
