Or easy way STRAIGHT JSP... again Jsp Vs Cfm topic... i guess MM would
suggest the below and learn Java.. rather than incorporating these
capabilities
into CFMX.
JSP is some like..
Class.forName("macromedia.jdbc.MacromediaDriver");
Connection con=
DriverManager.getConnection("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 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");
> con = foo.getConnection(url, user, pass);
> dbmd = con.getMetaData( );
> allTables = dbmd.getTables(null,null,null,tableTypes);
>
> *
> *
> *
>
> </cfscript>
>
>
> The problem is that CF has no concept of a null value, so you can't
> pass a null in the statement:
>
> allTables = dbmd.getTables(null,null,null,tableTypes);
>
> And, if you are restricted to CFMX only, you are SOL!
>
> Dick
>
>
> On Thursday, September 19, 2002, at 07:09 AM, Joshua Miller wrote:
>
> > 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 it using SQL Meta Data, but that's RDBMS specific, is
> > there a way to do it with CFML and CFOBJECT?
> >
> > Thanks,
> >
> > Joshua Miller
> > [EMAIL PROTECTED]
>
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
