<cfquery> instead of using the JDBC API directly. In fact, if you use
<cfqueryparam>, the database turns your query is turned into a
prepared statement the first time it is called and sends back a handle
to the JDBC driver. For all subsequent calls to that query, only the
handle and the bound parameters are sent to the database--not the
entire query.
On Tue, 21 Sep 2004 22:59:41 -0400, Joe Eugene <[EMAIL PROTECTED]> wrote:
> Yes, i have looked at <cfQueryParam>. I dont think it works the same as
> below.
> http://java.sun.com/j2se/1.4.2/docs/api/java/sql/PreparedStatement.html
>
> Joe Eugene
>
> -----Original Message-----
> From: Matthew Fusfield [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 21, 2004 9:28 PM
> To: CF-Talk
> Subject: Re: Prepared Statements in CFMX
>
> Have you looked into <CFQUERYPARAM> ?
>
> It allows you to do parameterized queries and does type checking.
>
> Matt
>
> On Tue, 21 Sep 2004 21:03:42 -0400, Joe Eugene <[EMAIL PROTECTED]>
> wrote:
> > Is there an easy way to execute a Prepared Statements directly in CFMX?
> > i.e Using the API via <cfscript>, just like java prepared statements?
> >
> > Thanks,
> > Joe Eugene
> >
> >
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
