> Hi list, with the following script (below) I am > checking duplicate eMails and I delete > them after checking them.
you don't say what db BUT if its sql server (or another db with similar index functionality), i'd just let the db do the hard work: create another table duplicating your original table but put a unique index with ignore duplicate key property on your email column. CREATE UNIQUE INDEX emailIDX ON blabla(email) WITH IGNORE_DUP_KEY then simply INSERT/SELECT from the old table into the new one. sql server will accept the first email, but throw away (ignore) all the duplicate ones. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
