Les Mizzell wrote: > 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?
Just to make sure that you understand that <cfqueryparam...> is not having a problem with a list of over 2100 items. Your database is having a problem with a parametrized list of over 2100 items. I.E. If you where to manually send the database a parameterized sql statement with the same sized list, you would get the same error. If the query successfully runs without a <cfqueryparam...> it just means that the DBMS can handle longer unparameterized lists. But databases still have maximum sizes they can handle for an 'IN' clause. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:319693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4