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:356495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm