no I didnt mean IE as in Internet Explorer, I said IE. as in "i.e.":
latin meaning that is..
It's finally fixed... the order by got me..
The code I had worked in dev but didnt in prod.. the order by was messed up.
Same data, same CF code, but in dev the code was outputting correctly,
in prod it wasnt.
I threw in another variable to order by and that fixed the output from
the query.
To solve the problem with the server crapping out on me I used the
<cffile append function.
<cffile action="WRITE" file="#g_EcountFileDirectory#\#eCountFilename#"
output="#ecount_file_header#" addnewline="Yes">
<cffile action="APPEND"
file="#g_EcountFileDirectory#\#eCountFilename#"
output="#ecount_batch_header#" addnewline="Yes">
<cfloop query="fetchReferrals">
<cffile action="APPEND"
file="#g_EcountFileDirectory#\#eCountFilename#" output="#record_data#"
addnewline="Yes">
</cfloop>
<cffile action="APPEND"
file="#g_EcountFileDirectory#\#eCountFilename#"
output="#ecount_batch_footer#" addnewline="Yes">
<cffile action="APPEND"
file="#g_EcountFileDirectory#\#eCountFilename#"
output="#ecount_file_footer#" addnewline="Yes">
In doing so I had to modify my SQL to remove the line break in.
Anyways it seems to work just fine.. just took all day
On Mon, 22 Nov 2004 18:33:25 -0400, Larry White <[EMAIL PROTECTED]> wrote:
> I'm a little confused. Your first post said "IE" then showed
> output with extra linefeeds. Did you mean IE as in for example,
> or IE as in Internet explorer output? You shouldn't see linebreaks
> in HTML output unless you enclose them in PRE tags, or use some
> other method. You should see them in notepad or your text editor.
>
>
>
>
> > Can you provide an example of a couple of lines of the output? You
> > might try not providing any line breaks in your output to the append
> > line. I have a vague memory that each append call creates it's own
> > line break.
> >
> >
> > --------------
> > Ian Skinner
> > Web Programmer
> > BloodSource
> > www.BloodSource.org
> > Sacramento, CA
> >
> > "C code. C code run. Run code run. Please!"
> > - Cynthia Dunning
> >
> >
> >
> > Confidentiality Notice: This message including any
> > attachments is for the sole use of the intended
> > recipient(s) and may contain confidential and privileged
> > information. Any unauthorized review, use, disclosure or
> > distribution is prohibited. If you are not the
> > intended recipient, please contact the sender and
> > delete any copies of this message.
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185091
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
