<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]

