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/
