OK thanks guys. So similar to doing a cron job. Kind Regards,
Rick Sanders T: 902-401-7689 W: www.webenergy.ca -----Original Message----- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: Monday, August 19, 2013 12:13 PM To: cf-talk Subject: Re: Pausing a loop or query Kinda hacky, but: Use a db table/column for misc crap, or hell, even a server variable, and save something called: lastRow, 1 Do a SQL to get 250 addresses starting at row lastRow. Process your mail. When done, set lastRow to lastRow + 250. All of the above would be a CFM hit via cfschedule. On Mon, Aug 19, 2013 at 9:55 AM, Rick Sanders <r...@webenergy.ca> wrote: > > Here's the situation. A client of mine has an email list he sends a > flyer to once a month to about 5000 addresses. I need to pause after > sending 250 so the server doesn't get flagged for spamming. What's the > best way to do this? > > It's easy to do multiple queries of 250 rows each, but how can I pause > for say 5 or 10mins in between? > > Kind Regards, > > Rick Sanders > T: 902-401-7689 > W: www.webenergy.ca<http://www.webenergy.ca/> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356496 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm