/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
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/PreparedState
ment.html
Yes, that's exactly what it does. The CFQUERYPARAM tag creates a prepared
statement. If you look at your debug output when using CFQUERYPARAM,
Would that have something to do with the error I get if I run a query
using cfqueryparam , make a slight change to database structure and
then run the query again? If I remove the cfqueryparam it works fine
and if I wait awhile before running the query again it does fine.
Almost acts like it's
Would that have something to do with the error I get if I run
a query using cfqueryparam , make a slight change to
database structure and then run the query again? If I remove
the cfqueryparam it works fine and if I wait awhile before
running the query again it does fine.
Almost acts
As much as I hate SELECT * , I am using it in this case on some
admin pages rather than code individual queries for each table...pure
laziness.Never noticed that behavior under CF5 using ODBC.
Thanks,
Ken
On Wed, 22 Sep 2004 12:13:29 -0400, Dave Watts [EMAIL PROTECTED] wrote:
Would that have
As much as I hate SELECT * , I am using it in this case on
some admin pages rather than code individual queries for each
table...pure laziness.Never noticed that behavior under CF5
using ODBC.
It will only occur if you change the database structure and you're using an
existing query plan
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]
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
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
9 matches
Mail list logo