Thenks for the info Critter. Much appreciated. :)
Now for a little story about what happened today. I created a newsletter
page so that a registered base of 150,000+ subscribers would get it on
what would most likely be a weekly basis. On its first run today however,
it sent out approximately 2000 emails and then... exploded. It didn't just
stop sending emails though, instead the entire server got fried!
I called up the ISP and they say there's massive corruption throughout the
harddrive!?!?! WTF? Since the only thing that happened out of the
oridinary was the newsletter mailing today, they surmised that it was the
cause of the meltdown. Once again I ask... WTF?! Is ColdFusion unstable to
the point that sending out a newsletter would fry the server?!? One theory
is that messages got bounced back to the server and it couldn't handle the
load of outgoing and incoming. Ok fine, i'll buy that partially. Maybe it
was indeed a wussy server. But corruption? File corruption from
getting/sending emails? Hell the server wont even boot up now!
Has anyone else had this happen to them?
So here's a word of caution to anyone doing a newsletter from me. Try not
to fry your server in the process. *laugh* I still can't believe this
happened.
Oh yeah, for those interrested in the code that allegedly melted down the
server, here it is:
<cfquery datasource="zzz" name="newsletter">
SELECT date, slug, content
FROM newsletter
WHERE newsletter_id=#form.tid#
</cfquery>
<cfquery datasource="zzz" name="receivers">
SELECT email_address
FROM members
WHERE newsletter_flag=-1
</cfquery>
<cfmail TO="#receivers.email_address#"
FROM="[EMAIL PROTECTED]"
BCC="[EMAIL PROTECTED]"
QUERY="receivers"
SUBJECT="#newsletter.slug#">
ZZZ Newsletter
#DateFormat(newsletter.date, "DDDD, MMMM D YYYY")#
#receivers.email_address#
=================================================================
#newsletter.content#
=================================================================
UNSUBSCRIBE
Here's how to unsubscribe or change your settings.
http://www.zzz.com/updateprofile.asp
</cfmail>
.. and yes, that's how I know 2000 emails got sent out, because I got
2000+ blind CC's. Left it in there from the testing phase. Ugh.
--------------------------------------------------------------------------
Bryant Tyson, WEB DEVELOPER
http://webtys.com
WebTY's, The Educated Choice.
On Sun, 28 Oct 2001, Critz wrote:
> oi Bryant!!
>
>
> CHR(13)& CHR(10) is carriage return, line feed
>
> --
> Best regards,
>
> Critter [critz.org]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
