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 fine! > > <cfquery name="getReportSecurity" datasource="Reports"> > SELECT > A.ID, > A.Name, > A.URL, > A.Folderpath, > A.Description, > B.Id, > B.userName, > C.ID, > C.groupName > FROM > rpt_Reports A LEFT JOIN rpt_requiredUser B ON > A.ID = B.reportID > LEFT JOIN rpt_requiredGroup C on A.ID = > C.reportID > WHERE > A.URL = <cfqueryparam cfsqltype="cf_sql_varchar" > value="#reportAddress#"> > </cfquery> > > Anyone have any idea's on this one, I may end up re-starting Coldfusion, > and I don't like that! =( > > 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:274946 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
