Quizzes & Puzzles5 mins ago
sql trigger
1 Answers
I would like to create a website where users can search to see if anything matches their requirements, and if they can't find anything, they can input their details so that an email is automatically generated when something matching their profile is added to the site.
Could anyone tell me (in v simple terms) how to use a trigger to do this?
Could anyone tell me (in v simple terms) how to use a trigger to do this?
Answers
Only 1 answer
Best Answer
No best answer has yet been selected by chazza. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
Oracle or SQL Server trigger?
I'm not entirely sure I can answer in simple terms. Triggers aren't simple you see.
I would send the email in the code and not from the database. A database has no business sending emails (there are circumstances like DB failure etc). There are lots of examples of sending email from a website in all the various scripting languages (PHP, ASP, ASP.NET Perl).
Hope this helps.
I'm not entirely sure I can answer in simple terms. Triggers aren't simple you see.
I would send the email in the code and not from the database. A database has no business sending emails (there are circumstances like DB failure etc). There are lots of examples of sending email from a website in all the various scripting languages (PHP, ASP, ASP.NET Perl).
Hope this helps.
Only 1 answer
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.