I think I remember someone talking about there being a limit on the length of the list in an IN clause.
Can't remember the details though I thought itwas a limitation on the IN and not the param'd version. Check the archives, I'm sure you'll find it. Adrian -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: 15 September 2008 21:37 To: CF-Talk Subject: cfqueryparam - couple ofquestions from a problem that occured today... My original query code below, which has been running for months with no error, suddenly start throwing an unspecified database error today, plus actually timed out once, and the server reset in the middle of the query another time: Select ... from ... WHERE ml_id IN (<cfqueryparam value="#ValueList(getGROUP.ml_id)#" cfsqltype="CF_SQL_INTEGER" list="yes" />) Since I was at lunch and the client got p*ssed (I have no life of my own with this client), they got somebody else to look at the page. They changed the code to: WHERE ml_id IN (<cfoutput query="getGROUP"> <cfif getGroup.CurrentRow NEQ 1>,</cfif> #ml_id# </cfoutput>) .....no error. No timeout. No server reset. Specific query in question was returning approximately 5000 records - basically a first name, last name, and an email address. I don't get it. Shouldn't the cfqueryparam version perform *better*?????? Ideas? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312551 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
