I'm using MySQL.
I have this now:
<cfscript>
email_list =
replace(valuelist(list.email,"|"),"|",chr(13)&chr(10),"ALL");
</cfscript>
<cffile action="write" file="#ExpandPath("users.lst")#"
output="#email_list#">
It takes about 70 seconds to run. Which is ok by me for right now. I'm
going to try and schedule it to run late night.
It would be super nice though if I could get the db to do what I want.
--
Chris Edwards
Web Application Developer
Outer Banks Internet, Inc.
252-441-6698
[EMAIL PROTECTED]
http://www.OuterBanksInternet.com
----- Original Message -----
From: "Philip Arnold" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 01, 2003 10:48 AM
Subject: RE: how to make it go faster?
> > I have this:
> > <cfset emailtowrite = "">
> > <cfloop query="list">
> > <cfset emailtowrite = list.email & chr(13) & chr(10)>
> > <cffile action="append"
> > file="#ExpandPath("users.lst")#" output="#emailtowrite#">
> > </cfloop>
> > It still takes forever. Is there a faster method?
>
> Which database engine is it?
>
> If it's SQL Server, then can't you use DTS?
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
