Send Mail based on Form Value - Only Once!

[cyberbob2]

Hello,
I've been racking my brains over this one. I have a Classic ASP edit form with many fields, one of them a Status drop-down. If the Status (option value) has been changed to "Pending" for instance, I do a objMail.send, otherwise it doesn't send. No problem, but how can I prevent the mail from sending AGAIN if a user goes back to the page and updates another field, or even just refreshes the page? If it helps, I am updating a SQL Server database. Any help sure would be appreciated.
Thanks in advance, KP

 

[Sheco]

You could use a session variable or, since you are already updating a database you could check a field value and make the "send or don't send" decision based on the value.