Thanks, but the CFC is a bit beyond me at the moment. How would I insert it in a CFM page ?
----- Original Message ----- From: "Gerald Guido" <[email protected]> To: "cf-talk" <[email protected]> Sent: Monday, March 30, 2009 2:25 PM Subject: Re: Finding schema details with CF 6.1 ? > > Sorry about that.... I had my coffee now... I wrote a query to do that a > while back. I can't find it now. :-( > > Brian Rinaldi has a CFC in his CFC generator (Illudium) project that will > tease this out for you. > > http://code.google.com/p/cfcgenerator/source/browse/trunk/cfcgenerator/com/cf/model/datasource/mysql.cfc > > There are other cfc's in there for other DB's > > http://code.google.com/p/cfcgenerator/source/browse/trunk/cfcgenerator/com/cf/model/datasource/ > > HTH > > G! > > > On Mon, Mar 30, 2009 at 9:19 AM, BobSharp <[email protected]> wrote: > >> >> MySQL >> >> See previous posts in this thread. >> >> I have done it for a list of Tables, now need to >> extract FULL details of individual Tables. >> >> >> >> >> ----- Original Message ----- >> From: "Gerald Guido" <[email protected]> >> To: "cf-talk" <[email protected]> >> Sent: Monday, March 30, 2009 1:55 PM >> Subject: Re: Finding schema details with CF 6.1 ? >> >> >> > >> > What database are you using? There are different dialects on how to >> tease >> > that out. I would take a look at sql.cfc for the MSSQL . I have the >> > sql >> > for >> > MySQL some where in my archive if you need it.. >> > >> > >> > H! >> > >> > On Mon, Mar 30, 2009 at 6:57 AM, BobSharp <[email protected]> >> > wrote: >> > >> >> >> >> Can I use CF 6.1 (including hot fixes) >> >> to see what tables are in the schema ? >> >> >> >> >> >> >> >> >> >> -- >> >> I am using the free version of SPAMfighter. >> >> We are a community of 6 million users fighting spam. >> >> SPAMfighter has removed 12840 of my spam emails to date. >> >> Get the free SPAMfighter here: http://www.spamfighter.com/len >> >> >> >> The Professional version does not have this message >> >> >> >> >> >> >> >> >> > >> > >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
