You meant arrayToList(), right?
> -----Original Message-----
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 11, 2003 3:52 PM
> To: CF-Talk
> Subject: Re: Writing Query Results to a CSV using CFFILE
>
>
> Barney Boisvert wrote:
> > Don't use multiple calls to CFFILE, as they carry the overhead of file
> > system access. Instead concatenate a string variable, and then
> write it all
> > to the file in one call to CFFILE:
> >
> > <cfloop query="get____">
> > <cfset s = s & "...." />
> > </cfloop>
> >
> > <cffile action="write"
> > file="..."
> > output="#s#" />
>
> Don't use a string for this, use an array. Strings are way to slow for
> this in MX.
>
> <cfscript>
> tempArray = ArrayNew();
> ArrayAppend(tempArray,"RecordID,FirstName");
>
> for (i=1 ; i LTE online_reg.recordcount ; i=i+1)
> ArrayAppend(tempArray,"#ID#,#FirstName#");
> </cfscript>
>
> <cffile action="write"
> file="#exportFilePath#"
> output="#ArrayToString(temArray,chr(13)&chr(10))#"
> addnewline="no">
>
> Jochem
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
