Send Mail based on Form Value - Only Once!

[Kermit Piper]

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

 

[Patrice]

Not sure what exactly it is, but you could just keep an indicator (either a
boolean or perhaps a date) that allows to know if a mail was sent for this
item...

 

[Chris Hohmann]

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

Store old_status in a hidden form field. Compare that to the new_status
value when the form is submitted. If they're different, email.