sql trigger

[chazza]

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?

[OBonio]

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.