It should be simple to create a temp table with a unique or PK constraint on the email address. Set your cftry/catch "database" statement to empty. Then loop over that file inserting each email address as you go. When it tries to insert a dupe record, it would hit the empty catch block and essentially do nothing, but the email address would not be inserted twice.
-----Original Message----- From: Chad McCue [mailto:[EMAIL PROTECTED] Sent: Thursday, January 31, 2008 1:18 PM To: CF-Talk Subject: Very Large List Uploads I have a client uploading a .xls file containing 30k email addresses. I first need to read that excel file which is fine, reading it with a excel data source. I then need to parse through to remove all duplicate emails and then insert into a table. My system keeps timing out. The last file that worked had only 6k email addresses. Anyone know how to handle large lists? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297844 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
