write text file to the server

[AkronNick]

What I am trying to do is get query results then use the results mixed with a
little bit of simple HTML and then save that as a .txt file in a specific
location on my server... can this be done? I am using the .txt files in flash.
Unless Flash can call .cfm files into the text area component but I am
starting here first... anybody know anything about this? Many Thanks

[JMGibson3]

Sure Can: <CFFILE ACTION='Write' FILE='\\Server\xxx.txt'
OUTPUT='#YourContent#'> where your content is a huge string with all your
lines. If your using HTML to format you just keep concatenating (&amp;) your
lines into YourContent. If they're truly going to be a .txt you'll need an
extra &amp; chr(10) at the end of each line for them to look good in wordpad or
where ever. You can also <CFFILE ACTION='Append' FILE='\\Server\xxx.txt'
OUTPUT='#YourLine#'> to add lines one at a time with or without chr(10) to the
end of an existing file. Be aware that this approach can get horribly
expensive as file size increases since each Append operation actually reads the
entire file into memory, adds the line, and writes it back.

[AkronNick]

Thanks, I figured that out by searching the archives - should have done that in
the first place but thanks for the advice on performance - however in my case
this will only happen once every so often so I'm not too concerned. thanks
again!