Orson Jones wrote:
Jim Anderson wrote:
initial looks tells me that the following won't work either. run the
following:

SELECT DATE_ADD('2007-02-28', INTERVAL 6 MONTH) + INTERVAL 49 DAY = CURDATE();
SELECT DATE_ADD('2007-03-01', INTERVAL 6 MONTH) + INTERVAL 45 DAY = CURDATE();

those 2 queries both return true. notice, though, that they are 1
calendar day apart and 4 interval days apart. this is going to have the
same basic effect as before. :(

I don't think that would have the same problem. (4 emails sent.) I believe it
would actually send only 1 email. (You might have a few days interlude that no
emails are sent to anyone, but never four emails in a row.)

Orson
not sure. i also felt that was a potential threat and can afford to have to answer to the "why didn't these people get that email?" question. this solution just doesn't seem robust enough. :(

thnx,
-jim


_______________________________________________

UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net

_______________________________________________

UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net

Reply via email to