> 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.
