Rick - Try setting max pooled statements to 0 in CF admin for the problematic datasource(s).
I've seen "x >= x" errors and "Variable cannot be converted to requested type" errors when adding / removing columns from tables. Changing the max pooled statements setting fixed our problem. See more in the thread below. http://www.houseoffusion.com/cf_lists/messages.cfm/Threadid=34563&forumi d=4𪣞 Pat -----Original Message----- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, May 27, 2005 7:57 AM To: CF-Talk Subject: One more try... 7 >= 7? Anyone ever seen this? Error Occurred While Processing Request 7 >= 7 the query is a simple select query... SELECT * FROM GALLERY_PHOTOS where blog_id=<cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#blog_id#"> and gallery_id=<cfqueryparam cfsqltype="CF_SQL_INTEGER" value="#GALLERY_ID#"> This is occuring in SQL Server 2000... sporadically, according to the person who reported the bug. I can't duplicate it though. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207880 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
