That's very cool Clint, have you written a web version of the sql client so
that you can query the database and see your result set's?
Bryan
----- Original Message -----
From: "Clint Tredway" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 9:01 AM
Subject: Re: How to get a list of all tables in a given datasource - and how
to combine queries
| Getting all the tables for a SQL database is simple. Just query the
system table 'sysobjects' with this query:
|
| Select name,xtype from sysobjects where xtype = 'u' and name not like
'dt%' Order By Name
|
| For your second question it will take some logic to do what you want. Go
look at this app that I am writting. It is a web based sql manager.
|
| www.factorxsoftware.com/sqlmanager
|
| HTH
|
| Clint
|
| ---------- Original Message ----------------------------------
| From: "JoshMEagle" <[EMAIL PROTECTED]>
| Reply-To: [EMAIL PROTECTED]
| Date: Fri, 08 Jun 2001 08:34:07 -0400
|
| 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
