How about -
<!--- Tab-delimited --->
<cfset Delimiter = Chr(9)>
<cfset EndLine = Chr(10) & Chr(13)>
<!--- Write column headers --->
<cfloop list="#yourquery.ColumnList#" index="i">
<cffile action="APPEND"
file="yourfile"
addnewline="no"
output="#i##Delimiter#">
</cfloop>
<!--- Start new line --->
<cffile action="APPEND"
file="yourfile"
addnewline="yes"
output=" ">
<cfloop query="yourquery">
<!--- Output each field --->
<cfloop list="#yourquery.ColumnList#" index="i">
<cffile action="APPEND"
file="yourfile"
addnewline="no"
output="#evaluate( "yourquery.#i#" )#">
</cfloop>
<!--- Start new line --->
<cffile action="APPEND"
file="yourfile"
addnewline="yes"
output=" ">
</cfloop>
-----Original Message-----
From: Mak Wing Lok [mailto:[EMAIL PROTECTED]]
Sent: 30 January 2001 02:37
To: CF-Talk
Subject: cfoutput into a text file
how can i write a query result into a text file?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
