I've got an application that a client uses to import email list from Excel spreadsheets into a database for use to send e-newsletters to specific groups.
The database has grown quite large, and when importing list to specific group at this point, they're forgetting if a particular email address had already been added, and needs something that prevents duplicates from being added to the list. I can think of a couple of clumsy (resource intensive) ways to check the addresses being imported against what's already in the database, but there must be an optimal way to do it. <cf_check_duplicates_before_insert> ?? Suggestions? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305921 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
