Use Select Distinct.
<cfquery name="get_emails" datasource="MyExcelDSN">
SELECT DISTINCT strEmailAddress
FROM myEmailList
</cfquery>
On Jan 31, 2008 2:18 PM, Chad McCue <[EMAIL PROTECTED]> wrote:
> 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:297852
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
