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.
