Well I'm stuck! Anyone else care to try?
Paul
PS Maybe you could create a variable and write that out to a file and strip
out any blank lines? Then you could locate the user to a page that
downloads the file as a csv... Dunno! It's a solution, but a bit scrappy,
but it should work!
> -----Original Message-----
> From: Rich Wild [mailto:[EMAIL PROTECTED]]
> Sent: 17 October 2000 12:27
> To: CF-Talk
> Subject: RE: Extra records in CSV file generation
>
>
> Paul,
>
> I tried repositioning the cfsetting tag as you said - but am still getting
> the extra fields...
>
> Here is the code - all on one line.
>
> <CFHEADER NAME="Content-Disposition" VALUE="inline;
> filename=mangobase_#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><cfsetting enablecfoutputonly="no">
>
> Again, it doesn't matter what records are pulled out of the db,
> it could be
> none, one or 27000 + etc - always 7 blank records at the end....
>
> This says to me that its not data in the db - I've looked for that anyway.
>
> The fact that I've tried Cfsetting and cf_lesswhitespace and putting the
> code all on one line says to me that its not spurious carrige returns or
> code formatting....
>
> I've tried it using OLEDB and ODBC - same result...
>
> I've tried putting the whole SQL statement on 1 line - same result... (I'm
> getting desperate now you can tell!)
>
> ay ay ay...
>
> I mean, its only a cosmetic problem, right? Or is it? Perhaps those 7
> records could kill the customer's queries on that data or affect his/her
> insertion into their accounting etc...
>
> must...find....answer.... *gasp*
>
> -------------------------------------------------------
> 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.
