Web Notifications - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

ajwhite · 10-21-2009, 08:09 PM

Hey -

So I am working on developing a notification system for my classifieds website. If a user searches for an item and it doesn't exist yet in the classifieds, the user has the option of being notified when the item is added to the database.

Should I go about this as follows? :

Whenever a user uploads an item, the upload stored procedure should also call another procedure to check if the item matches any items in the notifications table of the database.

If there is a match between both items, the user will be notified. Should I create a procedure that upon an item being uploaded, the script will check if it should notify, and return true to my asp page. When true, the codebehind will send an email from the asp page itself.

Is this the best way to do this?

Is there a way for the database itself to send an email? Or should this all be on the asp server side of things?

Gregorio · 10-22-2009, 11:02 PM

Try doing it all on the asp server side. Test if it works if not come back and post if it doesn't. Other than that you can wait till a more knowledge person other than me to reply to this thread and help you out.

ajwhite · 10-23-2009, 10:50 AM

hmm well it will definitely work on the codebehind. If I have the stored procedure return true, then I can have it execute the send code in the codebehind. that will work. I just am wondering if I can skip that step and do this all from the database, and if it should be done whenever a user uploads a book or if it should be a reoccurring script to check for new uploads that matches notifications