RE: Could not find prepared statement with handle 2 - suddenly?

2007-04-10 Thread Adkins, Randy
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

RE: Could not find prepared statement with handle 2 - suddenly?

2007-04-10 Thread Peterson, Chris
, 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

Re: Could not find prepared statement with handle 2 - suddenly?

2007-04-10 Thread Kris Jones
, 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

RE: Could not find prepared statement with handle 2 - suddenly?

2007-04-10 Thread Dan G. Switzer, II
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

RE: Could not find prepared statement with handle 2 - suddenly?

2007-04-10 Thread Peterson, 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 datasource=Reports SELECT * FROM runReports

RE: Could not find prepared statement with handle 2 - suddenly?

2007-04-10 Thread Adrian Lynch
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

RE: Could not find prepared statement with handle 2 - suddenly?

2007-04-10 Thread Peterson, Chris
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,

Re: Could not find prepared statement with handle 2 - suddenly?

2007-04-10 Thread James Holmes
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