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:319689
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
