Hmmm, yeah Cheers Paul, I thought about doing that.
Spose I could write the file, serve the hard copy file, delete the file
see if that would make any difference than just serving up a file. Speed
isn't an issue here, as its an action that'll only be performed a few times
a week.
-------------------------------------------------------
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:44 PM
> To: CF-Talk
> Subject: RE: Extra records in CSV file generation
>
>
> 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=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.
