RE: Pausing a loop or query

2013-08-19 Thread Rick Faircloth
How about using a scheduled task to run a series of mail sends of 250 each, the as part of the task, schedules another task 5-10 minutes later to send another task. Repeat as needed. Here's what part of a scheduled task would look like that I used to process a Real Estate data download every morn

RE: Pausing a loop or query

2013-08-19 Thread Rick Faircloth
How about using a scheduled task to run a series of mail sends of 250 each, the as part of the task, schedules another task 5-10 minutes later to send another task. Repeat as needed. Here's what part of a scheduled task would look like that I used to process a Real Estate data download every morn

RE: Pausing a loop or query

2013-08-19 Thread Rick Sanders
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

Re: Pausing a loop or query

2013-08-19 Thread Raymond Camden
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.

Re: Pausing a loop or query

2013-08-19 Thread Dave Watts
> 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