<cfsavecontent variable="ecount_file">
<cfloop query="fetchReferrals">
<cfoutput>#record_data#</cfoutput>
</cfloop>
</cfsavecontent>
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 11:50 AM
To: CF-Talk
Subject: RE: Writing cfoutput to a text file
so, loop through it, make each field, have a #queryName.column#, value in
the cfsavecontent.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 12:41 PM
To: CF-Talk
Subject: RE: Writing cfoutput to a text file
Yes but I need to dump the whole query formatted just how the sql query
formats it.
-----Original Message-----
From: Matt Robertson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 22, 2004 10:54 AM
To: CF-Talk
Subject: Re: Writing cfoutput to a text file
You can't 'dump' it, but you can output it. Here's an example:
<cfquery
name="Maker"
datasource="test">
SELECT
myfile.FIELD1,
myfile.FIELD2
FROM myfile
WHERE
0=0
ORDER BY
myfile.FIELD1 ASC
</cfquery>
<cfloop query="Maker">
<cfset variables.DestFile="foo_" & Maker.FIELD1 & ".txt">
<cffile
action=""
output="#Maker.FIELD2#"
file="c:\cfusionmx\wwwroot\bar\#variables.DestFile#">
</cfloop>
--
--Matt Robertson--
MSB Designs, Inc.
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
