Maybe you hit a limit in the number of items valuelist or cfqueryparam could handle. try building the string outside the query with valuelist, to see if the valuelist triggers an error.. then use that string with cfqueryparam in your query and if it doesn't work, try the string (just once, not live:) without cfqueryparam to see if the cfqueryparam is causing the problems or maybe there is one bad data point causing a problem
At 04:36 PM 9/15/2008, you wrote: >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:312552 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
