Making no code or server changes (that I know of), this morning an application that I have had going for 4 years+ started throwing this error:
Could not find prepared statement with handle 2 I tracked it down to this pretty simple query here: <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? Chris Peterson ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274925 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
