<div>
You may wish to look at the last example here (see &quot;to write all at once&quot;)<br />
<a href="https://www.experts-exchange.com/questions/20752794/How-can-I-write-a-CF-query-to-a-Text-file.html?qid=20752794" rel="ugc">https://www.experts-exchange.com/questions/20752794/How-can-I-write-a-CF-query-to-a-Text-file.html?qid=20752794</a>
</div>


You may wish to look at the last example here (see "to write all at once")
https://www.experts-exchange.com/questions/20752794/How-can-I-write-a-CF-query-to-a-Text-file.html?qid=20752794 [https://www.experts-exchange.com/questions/20752794/How-can-I-write-a-CF-query-to-a-Text-file.html?qid=20752794]

<div>
You can use the following:<br />
<br />
&nbsp;&lt;cfsavecontent variable=&quot;contentvar&quot;&gt;<br />
&nbsp;&lt;cfoutput&gt;text<br />
&nbsp;text and more text. and formatting<br />
&nbsp;&lt;/cfoutput&gt;<br />
&nbsp;&lt;/cfsavecontent&gt;<br />
&nbsp;<br />
&lt;cffile action = &quot;write&quot;<br />
&nbsp; file = &quot;c:\output\&quot;<br />
&nbsp; output = &quot;#contentvar#&quot;<br />
&nbsp; mode = &quot;777&quot;<br />
&nbsp; attributes=&quot;normal&quot;&gt; 
</div>


You can use the following:

 <cfsavecontent variable="contentvar">
 <cfoutput>text
 text and more text. and formatting
 </cfoutput>
 </cfsavecontent>
 
<cffile action = "write"
  file = "c:\output\"
  output = "#contentvar#"
  mode = "777"
  attributes="normal">

<div>
<div class="content wysiwyg-content">
I want to write data to a text file. I want to be able to control how the data will look in the text file so I was thinking of using recorddset fields and putting it all in one CF variable string and use cffile to output that one variable. I guess I want to know how to put all my data from my query into a single string variable.
</div>
</div>


I want to write data to a text file. I want to be able to control how the data will look in the text file so I was thinking of using recorddset fields and putting it all in one CF variable string and use cffile to output that one variable. I guess I want to know how to put all my data from my query into a single string variable.

writing a recordset 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.

Web Servers

Web development software is used to create websites for both the Internet and intranets. Software can be either locally installed or operated through a cloud interface, and ranges in complexity from simple text editors to full-fledged integrated development environments (IDEs) that include graphics, video, audio, scripting and database support.

Web Development Software

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.