Wrox Programmer Forums
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 31st, 2005, 10:24 AM
Registered User
Join Date: May 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default auto email reminder

Dear all,

i need to create a script that will check against the closing date of event from a database and send reminders to members automatically.

Any idea how can tis be accomplished, solution with coding samples will be greatly appreciated.

Thanks n Regards

Old June 1st, 2005, 02:54 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post

You can check the websites on CDO, CDOSYS or CDONTS to know how mailing code works.

Do a search on how to use ADODB.CONNECTION, ADODB.recordset object, to interact with database. That should put you on right path.

- Vijay G
Strive for Perfection
Old June 1st, 2005, 03:43 PM
uit uit is offline
Authorized User
Join Date: Jul 2003
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts

If the database is MS SQL Server, look into creating SQL that checks your date column for the appropriate criteria and then use CDO/CDOSYS/CDONTS (depending) to shoot out the email.

I didnt get involved with SQL Mail on SQL Server for various reasons, but you may want to look into that anyhow.

And, depending on if this date check is happening on the fly (as records are added, updated) then you may want to utilize a trigger (MS SQL Server) and run the SQL from the trigger. If you're looking to schedule it every X often, then look into the SQL Server Agent and its Job functionality.

www.aspfaq.com is a great resource from which I learned a good deal from.

If you're using MS Access or MySQL, I think you'll find similar facilities (no triggers in Access I dont think) and if Oracle then you'll find many similarities to MS SQL Server. Not too sure about MySQL but it looks to be somewhere in between Access and SQL Server in terms of Triggers and Job Scheduling.

The SQL itself is whatever you'd write to satisfy your date selection criteria and should execute against any database relatively unchanged except for each implementations date formatting.

Hope that helps a bit, good luck!

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sending Email as reminder derekl Classic ASP Basics 1 July 26th, 2006 09:10 PM
Auto Reminder Mail... anees ASP.NET 2.0 Professional 1 May 31st, 2006 02:30 AM
asp/sql auto email on specified date keyvanjan Classic ASP Professional 2 March 5th, 2006 09:14 PM
HELP Excel auto email jmunda Excel VBA 1 April 1st, 2005 06:33 AM
Auto Reminder Email netwizard_01 Classic ASP Basics 2 January 26th, 2005 10:32 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.