You would handle the line break like this:
<cfoutput query="hello">
<cfset Output = Output & "#fname,#lname# #chr(13)chr(10)#">
</cfoutput>
Hope that helps.
Shawn Grover
-----Original Message-----
From: Mookie Bear [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 1:37 PM
To: CF-Talk
Subject: RE: Writing to text file
why can't I do this????? i mean, I need to do this!! because i have to put
over 3,000 names!!!! How can I loop over a "write" CFFILE tag? because it
would keep making new files. why can't i put it all in one single thing? I
was also thinking putting all that info in one variable, but how do I
specify a line break in that variable? that line break is important,
because Access reads it as a new row. grrrrrr!!!
output="<CFOUTPUT query="hello">#fname#,#lname#
</CFOUTPUT>"
>From: "Adkins, Randy" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: Writing to text file
>Date: Tue, 11 Dec 2001 15:31:00 -0500
>
>If you need to nest the output of a query within the CFOUTPUT tags,
>simply use the CFLOOP function.
>
>
>-----Original Message-----
>From: Mookie Bear [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, December 11, 2001 3:27 PM
>To: CF-Talk
>Subject: Writing to text file
>
>
>hey guys, I am doing a CFFILE and writing to a NEW file (not appending). i
>am tyring to input information in text delimited from a query. how do I do
>this though? i cannot put CFOUTPUT query="whatever" inside the output.
>help!
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
