Ok, Ben's article in the new CFDJ has me thinking - there's a way to
display all the DSN connections using CFML and CFOBJECT, but is there a
way to display all the table names for a specific DSN? I'd like to write
a web-based version of the Studio DSN browser and that's the missing
link. I can do
You should be able to do it with cfobject and the JDBC drivers using
metadata. something like:
cfscript
url = jdbc:pointbase:cfsnippets,database.home=/opt/coldfusionmx/db;
user = PBPUBLIC;
pass = PBPUBLIC;
foo = CreateObject(java,com.pointbase.jdbc.jdbcUniversalDriver);
Forgot to post a URL that discusses metadata:
http://members.aol.com/kgb1001001/Articles/JDBCMetadata/
JDBC_Metadata.htm
HTH
Dick
On Thursday, September 19, 2002, at 08:29 AM, Dick Applebaum wrote:
You should be able to do it with cfobject and the JDBC drivers using
metadata.
(jdbc:macromedia:sqlserver,Username,Pass);
DatabaseMetaData md = con.getMetaData();
Yada Yada!
Joe
- Original Message -
From: Dick Applebaum [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 11:29 AM
Subject: Re: Getting List of Tablenames for a DSN
You should be able
://www.joshuasmiller.com/dsn_browser.zip
Joshua Miller
[EMAIL PROTECTED]
-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 11:44 AM
To: CF-Talk
Subject: Re: Getting List of Tablenames for a DSN
Forgot to post a URL that discusses
Wow, that's great Josh!
Where did you get the info on coldfusion.server.ServiceFactory?
Thanks,
Ken
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 10:33 AM
To: CF-Talk
Subject: RE: Getting List of Tablenames for a DSN
Thanks
That's courtesy of Ben Forta from the ColdFusion Developer's Journal.
Joshua Miller
[EMAIL PROTECTED]
-Original Message-
From: Ken Brocx [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 2:31 PM
To: CF-Talk
Subject: RE: Getting List of Tablenames for a DSN
Wow, that's
7 matches
Mail list logo