Thanks for all the help.
Takes ~ 14 seconds. Down from the original ~180
<!--- get email list --->
<cfquery name="list" datasource="#Request.App.Db#">
SELECT DISTINCT CONCAT(email,'\r\n') AS email
FROM `mail_subscriptions`
#optlist#
</cfquery>
<cffile action="write" file="#ExpandPath("users.lst")#"
output="#valuelist(list.email,"")#">
Once again, the DB shines through as the savior. Thanks Doug for reminding
me.
--
Chris Edwards
Web Application Developer
Outer Banks Internet, Inc.
252-441-6698
[EMAIL PROTECTED]
http://www.OuterBanksInternet.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
