Pausing a loop or query

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

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 how

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

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 Rick Faircloth
/cfthread Rick -Original Message- From: Rick Sanders [mailto:r...@webenergy.ca] Sent: Monday, August 19, 2013 10:55 AM To: cf-talk Subject: Pausing a loop or query 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

RE: Pausing a loop or query

2013-08-19 Thread Rick Faircloth
/cfthread Rick -Original Message- From: Rick Sanders [mailto:r...@webenergy.ca] Sent: Monday, August 19, 2013 10:55 AM To: cf-talk Subject: Pausing a loop or query 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