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/
