Can you change the query to use joins instead? Adrian
> -----Original Message----- > From: Les Mizzell [mailto:[email protected]] > Sent: 23 February 2009 18:48 > To: cf-talk > Subject: The command code was 0 ... What's "best Priactice" around > this? > > > Getting an error from a specific query: > > The DBMS returned an unspecified error. The command code was 0 > > Here's the problem: > > WHERE ml_id IN ( > <cfqueryparam > value="#ValueList(GetGROUP.ml_id)#,0" > cfsqltype="CF_SQL_INTEGER" > list="yes" /> ) > > > After some research, the ValueList is returning over 3000 records for > the particular query that's causing problems. Seems that over 2100 > (param) in a list will throw a "Command Code Was 0" error. > > OK - trying to be sure I adhere to "best practice" at all times. What > would you consider "best practice" if you know using cfqueryparam is > going to have a problem with a large list containing over 2100 items? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
