What database platform are you on? I'd import those email addresses in the CSV to a temporary table and then just use a sub-select in the where clause. Let the database do the work... DELETE FROM someTable WHERE emailaddress in (SELECT email from tempImportTable) Also, if you are on SQL Server and this is a routine that you will need to do every so often, create a SSIS Package to run the import from CSV and clean up the the table. They are pretty easy to create and all you need to do is refresh the CSV file for it to run. --Jeff
-------- Original Message -------- > From: "i...@markleder.com i...@markleder.com" <i...@markleder.com> > Sent: Wednesday, July 17, 2013 12:01 PM > To: "cf-talk" <cf-talk@houseoffusion.com> > Subject: Re: Compare Two Lists > > 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:356225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
