How about replacing it with:
Warning - Not tested !
<cfscript>
emails = replace(valuelist(list.email,"|"),"|",chr(13)&chr(10),"ALL");
</cfscript>
Marlon
Chris Edwards wrote:
>I have this loop that runs ~22,000 iterations. It brings the server to its
>knees. The RAM usage skyrockets above 800 Megs cutting into major virtual
>memory. But when I just write the output instead of storing it to a
>variable, it runs fine. I'm trying to retrieve a list of email addresses
>and then write them to a file.
>
> <cfscript>
> emails = "";
> for( i = 1; i lte list.recordcount; i=i+1 )
> {
> emails = emails & list.email[i] & chr(13) & chr(10);
> }
> </cfscript>
>
>I can't imagine that the list in memory would take that much room. Does
>anyone have a suggestion?
>
>--
>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
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
