If you do it this way you need "listQualify()" <cfset toDelete = listqualify(toDelete,")/>
Then you will need to "preservesinglequotes" in the query as in... WHERE emailAddress IN (#preservesinglequotes(todelete)#) That's one of the reasons that I USE cfqueryparam - to keep me from having to write list code :) -Mark -----Original Message----- From: Cameron Childress [mailto:[email protected]] Sent: Wednesday, July 17, 2013 2:10 PM To: cf-talk Subject: Re: Compare Two Lists Depending on where this CSV file is coming from, I'd just not use cfqueryparam. The only real reason to use it in a case like this is to make sure nobody's SQL injecting you. If this is an automated process and you think maybe one day you might not be able to trust the inputs form the CVS file, then you need to still worry. But it's it's just a one time thing, just use the good ole SQL syntax: WHERE emailAddress in (#todelete#) I'd stick to SQL too - comparing lists of this length in CF is going to be a really crappy slow experience. -Cameron On Wed, Jul 17, 2013 at 3:00 PM, [email protected] [email protected] < [email protected]> wrote: > > FWIW: I have 4000 records to delete, with CF 9, throws an error: > [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming request has too > many parameters. The server supports a maximum of 2100 parameters. Reduce > the number of parameters and resend the request. > > I can break up the routines into three sets to make it work. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356230 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
