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]

Reply via email to