A small word of warning / caution with this way of exporting, you may
want to split the data up into blocks and write "chunks" to the file
rather than the whole lot.

We had a situation where a user was impatient, we were exporting a lot
of data at the time and ending up killing the machine :(

----- Original Message -----
From: Tony Weeg <[EMAIL PROTECTED]>
Date: Tue, 22 Jun 2004 11:35:13 -0400
Subject: RE: Writing cfoutput to a text file
To: CF-Talk <[EMAIL PROTECTED]>

you should loop through it within the confines of a cfsavecontent tag and
then take that variable that cfsavecontent creates, and dump that to the csv
file.

dumbed down example:

<cfquery name=get>
<cfsavecontent variable="getResults">
<cfloop query="get">
<cfoutput>
#stuff1#,#stuff2#
</cfoutput>
</cfloop>
</cfsavcontent>
<cffile output="#getResults#" action="" Remove Footer Here-->
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to