How about sending us the code again with a sample output?
Paul
> -----Original Message-----
> From: Rich Wild [mailto:[EMAIL PROTECTED]]
> Sent: 17 October 2000 08:28
> To: CF-Talk
> Subject: RE: Extra records in CSV file generation
>
>
> > Well, have you checked there are no empty records in the db at all?
> >
> > Paul
> >
> > PS I assume you have, but it's only polite to ask!
>
>
> Thanks Paul, but yeah - I have :D
>
> -------------------------------------------------------
> 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: Paul Johnston [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, October 16, 2000 6:17 PM
> > To: CF-Talk
> > Subject: RE: Extra records in CSV file generation
> >
> >
> > Well, have you checked there are no empty records in the db at all?
> >
> > Paul
> >
> > PS I assume you have, but it's only polite to ask!
> >
> > > -----Original Message-----
> > > From: Rich Wild [mailto:[EMAIL PROTECTED]]
> > > Sent: 16 October 2000 17:11
> > > To: CF-Talk
> > > Subject: RE: Extra records in CSV file generation
> > >
> > >
> > > > Why not wrap it in a tag (see tag gallery) like
> > > >
> > > > <cf_stripwhitespace> or <cf_lesswhitespace> (see below)
> > >
> > > Unfortunately that didn't help either...... :(
> > >
> > > I think the problem may lie elsewhere...
> > >
> > > thanks for the help though.
> > >
> > >
> > > -------------------------------------------------------
> > > 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: Paul Johnston [mailto:[EMAIL PROTECTED]]
> > > > Sent: Monday, October 16, 2000 5:05 PM
> > > > To: CF-Talk
> > > > Subject: RE: Extra records in CSV file generation
> > > >
> > > >
> > > > 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.
> > ------------------------------------------------------------------
> > ------------
> > 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.
------------------------------------------------------------------------------
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.
