>- see footer for list info -<
Love the new scope you invented 'varaibles' :) Sent using BlackBerry® from Orange
-----Original Message----- From: Big Mad Kev <[EMAIL PROTECTED]> Date: Sun, 26 Oct 2008 20:27:57 To: Coldfusion Development<[email protected]> Subject: Re: [CF-Dev] cfmail capacity limit, CF8 with Win2003 SMTP >- 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 -<
_______________________________________________ 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 -<
