I need a little help not only on the backend part of this project, but the logistics of the project. First of all; my project is an order entry system. Several different companies log into the website to check status of their orders. I have this part working perfect. The login, the reports, Etc…. but now I came up with an idea that instead of these companies logging in everyday to check status of their orders. If they could click a button to get an email every time the status changed. That would be the greatest thing. What I thought could happened was; When they say they want an email. That order number would save to a table. With there email address which is already located in a users information table. And then every time a page is hit or I hit a page this code would check the table and find that order and if the status has changed from when they submitted the order number they would receive an email with all the information on it. But if no change to the order number it would skip over that user and not send an email. But here is were it get a little complicated, when the order is finally done and it says closed; It will send out the email and then take the user off the list and delete him/her from the table. Any help would be great. Either some direction, code, examples, Etc… anything. Now I do not know if this can be done with a stored procedure or triggers.
I am currently using MS SQL, ASP
Thanks for all the help in advanced.
Thank You
Joe
I am currently using MS SQL, ASP
Thanks for all the help in advanced.
Thank You
Joe