add a line break using #chr(10)#:
output="<CFOUTPUT query="hello">#fname#,#lname##chr(10)#
</CFOUTPUT>"
or, the really slow method:
you only create a new file on the first record - so do an append if you're
doing record 2+
<cfoutput qurey="hello">
<cfif currentRow eq 1>
<cfset action = "WRITE">
<cfelse>
<cfset action="APPEND">
</cfif>
<cffile action="#action#" file="test.txt" output="#fname#,#lname#"
addnewline="Yes">
</cfoutput>
---
Billy Cravens
----- Original Message -----
From: "Mookie Bear" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, December 11, 2001 2:36 PM
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
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
