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:185061 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54