Exceptional Greg!! This is what I am after, direct access to the jdbc conection object without having to create my own proxy class which couldn't get acces to cf datasources and drivers anyway.
I'll post my work a little later. Elliot "Greg Stewart" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Isaac Dealey wrote up an article on leveraging JDBC and CFMX, there > some code samples and other interesting bits and bobs: > > http://www.sys-con.com/story/?storyid=45569&DE=1 > > Cheers > G > > On Thu, 12 Aug 2004 14:18:40 +1000, Elliot Russo > <[EMAIL PROTECTED]> wrote: > > in a past life I have prgrammed asp (asp.net), vb, and done a bit of java - > > they all have a a little more features than cfquery :) > > > > "Barry Beattie" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > > > > > > > > sheesh! it's starting to look like Microsoft's ADO > > > > you're not a former ASP programmer, by chance, Elloit? > > > > cheers > > barry.b > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Elliot > > Russo > > Sent: Thursday, 12 August 2004 12:12 PM > > To: CFAussie Mailing List > > Subject: [cfaussie] Re: Using jdbc from Coldfusion > > > > I'd like access to the prepared statement methods. I am building my own > > in > > cf but it is a nuisance > > > > conn = createObject(); > > > > statement = conn.prepareStatement("select x from y where z = ?"); > > > > statement.setParameter(1, "test"); > > statement.setMaxRows(30); > > > > qResults = statement.execute(); > > > > then i want to add stuff like this where there are known named queries > > with > > known typed parameters > > > > statement = conn.getNamedStatement("getUsersByType"); > > statement.setParameter("type", "admin"); > > > > qResults = statement.execute(); > > > > Elliot > > > > "Mark Mandel" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > > > > Elliot, > > > > > > I've never (needed?) to use Java to write my own connection to my DB, > > > I've always been able to go through a CF datasource - even if it is > > > set up to go through a 3rd party jdbc driver. > > > > > > > I am creating some cfc to wrap my own database interactions but > > cfquery > > is a > > > > pain if you want to use cfqueryparam. and build dynamic sql > > statements > > > > > > I'm not sure what you mean by this? are you trying to extend cfquery > > > or something? > > > > > > I'm a tad confused :oP > > > > > > Mark > > > > > > On Thu, 12 Aug 2004 10:22:25 +1000, Elliot Russo > > > <[EMAIL PROTECTED]> wrote: > > > > Thanks Mark, seems the vendor driver is the way to go, found them > > with > > the > > > > client install. > > > > > > > > Have you/can you interact with the java objects from cf or do I > > need to > > do > > > > the whole shebang from in java. > > > > > > > > What i mean is should/can I create a class, to create and return a > > > > connection object and use that in cf to excute prepared statements > > etc > > or am > > > > i going to be casting all the time and be unable to access some > > method > > > > properly. > > > > > > > > > > > > > > > Elliot > > > > > > > > > -- > > > E: [EMAIL PROTECTED] > > > W: www.compoundtheory.com > > > ICQ: 3094740 > > > > > > > > > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to > > [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > > -- > e: greg.stewart(a)gmail.com > w: http://gregs.tcias.co.uk/ > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
