My guess is that Reportnumber is an INTEGER field but the CFQUERYPARAM
you are specifying indicates a VARCHAR field.
-Original Message-
From: Peterson, Chris [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 10, 2007 7:43 AM
To: CF-Talk
Subject: Could not find prepared statement with
, 2007 7:57 AM
To: CF-Talk
Subject: RE: Could not find prepared statement with handle 2 - suddenly?
My guess is that Reportnumber is an INTEGER field but the CFQUERYPARAM
you are specifying indicates a VARCHAR field.
-Original Message-
From: Peterson, Chris [mailto:[EMAIL PROTECTED]
Sent
, Randy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 10, 2007 7:57 AM
To: CF-Talk
Subject: RE: Could not find prepared statement with handle 2 - suddenly?
My guess is that Reportnumber is an INTEGER field but the CFQUERYPARAM
you are specifying indicates a VARCHAR field.
-Original Message
Chris,
cfquery name=getReportInformation datasource=Reports
SELECT *
FROM runReports
WHERE Reportnumber = cfqueryparam cfsqltype=cf_sql_varchar
value=#trim(url.report)#
/cfquery
I removed the cfqueryparam, and it starts working perfectly. Why would
this break all the suddon? Any idea's?
Using
Peterson
-Original Message-
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 10, 2007 9:09 AM
To: CF-Talk
Subject: RE: Could not find prepared statement with handle 2 - suddenly?
Chris,
cfquery name=getReportInformation datasource=Reports SELECT *
FROM runReports
I do X'.
Quick re-coding time =)
Chris Peterson
-Original Message-
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 10, 2007 9:09 AM
To: CF-Talk
Subject: RE: Could not find prepared statement with handle 2 - suddenly?
Chris,
cfquery name=getReportInformation
Actually, I am getting the same prepared statement error on another
query that looks fine!
cfquery name=getReportSecurity datasource=Reports
SELECT
A.ID,
A.Name,
A.URL,
Temporarily set max pooled statements to 0 for that datasource. Then
set it back to wherever you had it. It might work, it might not, but
it's worth a go.
On 4/10/07, Peterson, Chris [EMAIL PROTECTED] wrote:
Actually, I am getting the same prepared statement error on another
query that looks
8 matches
Mail list logo