Why not wrap it in a tag (see tag gallery) like
<cf_stripwhitespace> or <cf_lesswhitespace> (see below)
They take out all whitespace from a cf document after it's been processed.
It may sort it out, it may not.
Paul
PS <cf_lesswhitepace> from http://www.bjork.net/taggallery/index.htm is my
personal favourite.
> -----Original Message-----
> From: Rich Wild [mailto:[EMAIL PROTECTED]]
> Sent: 16 October 2000 16:43
> To: CF-Talk
> Subject: RE: Extra records in CSV file generation
>
>
> > Maybe wrap the entire thing in <cfsetting
> > enablecfoutpuonly="1"><cfsettingenablecfoutputonly="0"> [sic]
>
> Hi Aaron,
>
> Unfortunately that didn't work either. hmmmm
>
> I even tried putting the whole code on one line. Difficult to read in
> studio, and didn't work either!
>
> -------------------------------------------------------
> Rich Wild
> Senior Web Designer
>
> -------------------------------------------------------
> e-mango.com ltd Tel: 01202 587 400
> Lansdowne Place Fax: 01202 587 401
> 17 Holdenhurst Road
> Bournemouth Mailto:[EMAIL PROTECTED]
> BH8 8EW, UK http://www.e-mango.com
> -------------------------------------------------------
> This message may contain information which is legally
> privileged and/or confidential. If you are not the
> intended recipient, you are hereby notified that any
> unauthorised disclosure, copying, distribution or use
> of this information is strictly prohibited. Such
> notification notwithstanding, any comments, opinions,
> information or conclusions expressed in this message
> are those of the originator, not of e-mango.com ltd,
> unless otherwise explicitly and independently indicated
> by an authorised representative of e-mango.com ltd.
> -------------------------------------------------------
>
>
>
>
> > -----Original Message-----
> > From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, October 16, 2000 4:06 PM
> > To: CF-Talk
> > Subject: RE: Extra records in CSV file generation
> >
> >
> > hey rich,
> >
> > Maybe wrap the entire thing in <cfsetting
> > enablecfoutpuonly="1"><cfsettingenablecfoutputonly="0">
> >
> > so your code would look like this:
> >
> >
> > <cfsetting enablecfoutpuonly="1">
> > <CFHEADER NAME="Content-Disposition" VALUE="inline;
> > filename=#dateformat(now(), "yyyymmdd")#_#timeformat(now(),
> > "HHmm")#.csv">
> > <CFCONTENT TYPE="application/unknown"><cfoutput>"CONTACT
> > ID","SET NAME","SET
> > LABEL","DATA"#chr(13)#</cfoutput><CFOUTPUT
> > QUERY="get_all">"#contact_id#","#set_name#","#item_label#","#i
> > tem_data#"#chr
> > (13)#</CFOUTPUT>
> > <cfsettingenablecfoutputonly="0">
> >
> >
> > Aaron
> >
> >
> > -----Original Message-----
> > From: Rich Wild [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, October 16, 2000 10:50 AM
> > To: CF-Talk
> > Subject: Extra records in CSV file generation
> >
> >
> > Gents and Ladies...
> >
> > I am having a right old headache generating a CSV file from data in a
> > database.
> >
> > The data is all returned fine, but at the end of every file
> > there are seven
> > blank fields, no matter what data is contained.
> > I'm pulling my hair out trying to find out why these seven lines are
> > added... I use almost identical code in another app, and it
> > never returns
> > any garbage!
> >
> > Anyone had this or know why this is happening?
> >
> > <CFHEADER NAME="Content-Disposition" VALUE="inline;
> > filename=#dateformat(now(), "yyyymmdd")#_#timeformat(now(),
> > "HHmm")#.csv">
> > <CFCONTENT TYPE="application/unknown"><cfoutput>"CONTACT
> > ID","SET NAME","SET
> > LABEL","DATA"#chr(13)#</cfoutput><CFOUTPUT
> > QUERY="get_all">"#contact_id#","#set_name#","#item_label#","#i
> > tem_data#"#chr
> > (13)#</CFOUTPUT>
> >
> >
> > -------------------------------------------------------
> > Rich Wild
> > Senior Web Designer
> >
> > -------------------------------------------------------
> > e-mango.com ltd Tel: 01202 587 400
> > Lansdowne Place Fax: 01202 587 401
> > 17 Holdenhurst Road
> > Bournemouth Mailto:[EMAIL PROTECTED]
> > BH8 8EW, UK http://www.e-mango.com
> > -------------------------------------------------------
> > This message may contain information which is legally
> > privileged and/or confidential. If you are not the
> > intended recipient, you are hereby notified that any
> > unauthorised disclosure, copying, distribution or use
> > of this information is strictly prohibited. Such
> > notification notwithstanding, any comments, opinions,
> > information or conclusions expressed in this message
> > are those of the originator, not of e-mango.com ltd,
> > unless otherwise explicitly and independently indicated
> > by an authorised representative of e-mango.com ltd.
> > -------------------------------------------------------
> >
> >
> > --------------------------------------------------------------
> > --------------
> > --
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> ------------------------------------------------------------------
> ----------
> --
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> ------------------------------------------------------------------
> ------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
