- see footer for list info -<
Hi Gary,
Its normally recommended to split your query.
So you may be better off adding the following attributes:
startrow & maxrows also setting spoolenable to true will help
I'd suggest you do something like this:
<cfset varaibles.maxtosend = 2000/>
<cfset varaibles.totalSent = 1/>
<cfloop condition="varaibles.totalSent LTE myMailingList.recordcount>
<cfmail query="myMailingList" maxrows="#varaibles.maxtosend#"
startrow="#varaibles.totalSent#" spoolenable="true">
<cfset varaibles.totalSent = varaibles.totalSent +
varaibles.maxtosend />
</cfloop>
I haven't tested this, but should help
--------------------------------------------------
Big Mad Kev
Adobe Community Expert (ColdFusion)
email: [EMAIL PROTECTED]
blog: http://inner-rhythm.co.uk/blog
--------------------------------------------------
On 26 Oct 2008, at 20:09, Gary wrote:
- see footer for list info -<
Hi CF'ers. :-) Has anyone encounted a limit sending emails from CF8
via a
Windows 2003 SMTP server? Using <cfmail query="myMailingList"> with
at least
4,000 email addresses in the query, about 50 to 300 emails aren't
sent and
end up in the undeliverable directory.
CF logs this error: "552 4.3.1 Session size exceeds fixed maximum
session
size"
Adobe advised me to increase the SMTP session size limit above the
default
2Mb recommended by Microsoft. Okay, I increased it to 5Mb but if I
try to
send over 10,000 emails I run into the same problem. Increasing the
session
limit is *not* the correct solution. I feel this is a bug in CF that
prevents it from understanding what to do if SMTP closes the
session. CF
should simply open up a new session and carry on making sure to
resend the
last emails that weren't accepted by the SMTP server.
Anyone willing to share their experience or insight will be
appreciated.
Thanks,
Gary.
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists,
go to http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your
help -<
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
