Cool...how can I get a copy?
Cheers,
Brandon
----- 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
