yes, didn't someone post this the other day? :) Just kiddin....I have never seen this particular odd error. hey, try some Okham on it maybe. Remove the cfqueryparams, test, then add only one in, test, then remove and add the other test. My guess is you tried that already though. What about changing the cfsqltype, use numeric maybe. DK
On 5/27/05, Rick Root <[EMAIL PROTECTED]> wrote: > > 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207844 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54