I tried #chr(10)# and #chr(10)##chr(13)# ahvent tried just the chr(13) yet.. will do though, thanks.
On Tue, 23 Nov 2004 09:07:19 +1300, Matthew Walker <[EMAIL PROTECTED]> wrote: > Assuming there are no line breaks in your data, could it be that CF is > adding a CR + LF pair and these are both appearing individually as line > breaks? How about turning off addnewline, and simply adding your own: > output="#ecount_header##chr(13)#" etc. > > -- > Matthew Walker > www.ESWsoftware.com > > > > > > -----Original Message----- > > From: Greg Morphis [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, 23 November 2004 9:01 a.m. > > To: CF-Talk > > Subject: line breaks in files.. > > > > In my application I've ran into a problem.. > > <cffile action="WRITE" file="#g_EcountFileDirectory#\#eCountFilename#" > > output="#ecount_header#" addnewline="Yes"> <cfloop > > query="fetchReferrals"> > > <cffile action="APPEND" > > file="#g_EcountFileDirectory#\#eCountFilename#" output="#record_data#" > > addnewline="Yes"> > > </cfloop> > > <cffile action="APPEND" > > file="#g_EcountFileDirectory#\#eCountFilename#" > > output="#ecount_footer#" addnewline="Yes"> > > > > this is putting an extra line break.. > > IE.. > > 05 rec1 > > > > 07 rec2 > > > > 09 rec3 > > > > I'm needing > > 05 rec1 > > 07 rec2 > > 09 rec3 > > > > I've tried changing the addnewline to 'no' and even tried > > changing my SQL but this isnt working for me.. > > > > > > -- > > Auxilium meum a Domino > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185062 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

