<div>
you could output the query to a variable in the format that you want to have it stored <br />
<br />
&lt;cfset var=&quot;&quot;&gt;<br />
<br />
&lt;cfouptput query=&quot;yourquery&quot;&gt;<br />
cfset var= #var#+ #field1#,#field2#,#field3#<wbr />\n \\ not sure about the &quot;\n&quot; might need to be ascii char for newline<br />
<br />
&lt;\cfoutput&gt;<br />
<br />
and then use<br />
<br />
&lt;cffile action=&quot;write&quot; file=&quot;path/to/file.txt&quot; output=&quot;#var#&quot; addnewline=&quot;no&quot;&gt;<br />
<br />
or you might be able to output the query within the cffile tag<br />
<br />
output=&quot;&lt;cfouptput query=&quot;yourquery&quot;&gt;cfset var= #var#+ #field1#,#field2#,#field3#<wbr />\n \\ not sure about the &quot;\n&quot; might need to be ascii char for newline &lt;\cfoutput&gt;&quot; &nbsp;\\all in one line
</div>


you could output the query to a variable in the format that you want to have it stored

<cfset var="">

<cfouptput query="yourquery">
cfset var= #var#+ #field1#,#field2#,#field3#\n \\ not sure about the "\n" might need to be ascii char for newline

<\cfoutput>

and then use

<cffile action="write" file="path/to/file.txt" output="#var#" addnewline="no">

or you might be able to output the query within the cffile tag

output="<cfouptput query="yourquery">cfset var= #var#+ #field1#,#field2#,#field3#\n \\ not sure about the "\n" might need to be ascii char for newline <\cfoutput>"  \\all in one line

<div>
output=&quot;&lt;cfouptput query=&quot;yourquery&quot;&gt;cfset var= #var#+ #field1#,#field2#,#field3#<wbr />\n \\ not sure about the &quot;\n&quot; might need to be ascii char for newline &lt;\cfoutput&gt;&quot; &nbsp;\\all in one line <br />
<br />
should be<br />
<br />
output=&quot;&lt;cfouptput query=&quot;yourquery&quot;&gt;#field1#<wbr />,#field2#,<wbr />#field3#\n<wbr /> &lt;\cfoutput&gt;&quot; &nbsp;\\all in one line 
</div>


output="<cfouptput query="yourquery">cfset var= #var#+ #field1#,#field2#,#field3#\n \\ not sure about the "\n" might need to be ascii char for newline <\cfoutput>"  \\all in one line

should be

output="<cfouptput query="yourquery">#field1#,#field2#,#field3#\n <\cfoutput>"  \\all in one line

<div>
<div class="content wysiwyg-content">
Instead of writing my query to a table, I want to write it to a text file.<br />
Can someone help me with the code/syntax?<br />
<br />
Sue
</div>
</div>


Instead of writing my query to a table, I want to write it to a text file.
Can someone help me with the code/syntax?

Sue

How can I write a CF query to a Text file?

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.