I am guessing that there are some line breaks or something in your fields.
Either that or that the fields contain whitespace and nothing else and are
still coming out.
Maybe check for that when pulling the data out?
It doesn't seem to be outputting anything it shouldn't (or that it doesn't
think it should).
Other than that, I'm confused.
Paul
> -----Original Message-----
> From: Rich Wild [mailto:[EMAIL PROTECTED]]
> Sent: 17 October 2000 13:37
> To: CF-Talk
> Subject: RE: Extra records in CSV file generation
>
>
> I'll stick the last few lines of a sample file up at
> http://www.funjunkie.co.uk/csv/b0rked.csv (personal site) so that you can
> see whats happening...
>
> not quite sure where its getting this stuff from...
>
>
> -------------------------------------------------------
> 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: Tuesday, October 17, 2000 12:00 PM
> > To: CF-Talk
> > Subject: RE: Extra records in CSV file generation
> >
> >
> > Try putting <CFSETTING ENABLECFOUTPUTONLY="YES"> in the place
> > I've put it:
> >
> > Your code:
> >
> > > <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#","#item_
> > > data#"#chr
> > > (13)#</CFOUTPUT>
> > >
> >
> > My code (put it all into one line):
> >
> > <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><CFSETTING ENABLECFOUTPUTONLY="YES">
> > <CFOUTPUT
> > QUERY="get_all">"#contact_id#","#set_name#","#item_label#","#item_
> > data#"#chr(13)#</CFOUTPUT>
> >
> > I ran this with some of my data, and it worked fine without
> > any extra spaces
> > (also check there are no extra lines at all by putting it all
> > into one line!
> >
> > I hope this works!
> >
> > Paul
> >
> >
> > --------------------------------------------------------------
> > ----------------
> > 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.
