Status Change, Send out E-mail

[jmiller79]

Email automatically send out an email when the value of a field in a record changes?
For instance when someone looks at a record and the status says open. But they want an email as soon as the status changes to close. Can that be done and how or a brief idea. Thanks

 

[snowboardr]

When the user updates the database do an if statment like so:

'# some database code

If sStatus = "whatever" then
'# Do email code here
End If

www.sitesd.com
ASP WEB DEVELOPMENT

 

[JamesLean]

You may also like to look at setting up a trigger on the table that will send an email when the status is updated. Obviously this is dependent on the db you are using.

--James

 

[snowboardr]

James does MySQL support this option?

www.sitesd.com
ASP WEB DEVELOPMENT

 

[BillyRayPreachersSon]

MySQL v5.0.2 supports triggers:

http://dev.mysql.com/doc/mysql/en/Using_triggers.html

I found this by searching on Google for "mysql triggers".

Hope this helps,
Dan

 

[sedj]

snowboardr :

Don't think MySQL does support this email feature, but I'm sure MS Access does

 

[onpnt]

ouch

___________________________________________________________________

_{onpnt.com
SELECT * FROM programmers WHERE clue > 0
(0 row(s) affected) -->faq333-3811}

 

[snowboardr]

Ya I sense a little aggression.

www.sitesd.com
ASP WEB DEVELOPMENT