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.
