I have this website in ASP/Database driven website. In the database, I have a table with Members and Expiration Dates of their registrations.
I want the website to be able to send an email reminder automatically when that expiration date is reached.
I think I need some kind of Server Side component for this...if so, which one should I be looking at and is this doable?
02-27-2010, 05:33 AM
On your new web server you can setup a daily batch script scheduled to run and query your database of subscribers. Based on date of expiration (or whatever) you can email members.
I do this with several things including birthday emails daily.
02-27-2010, 08:16 PM
Care to offer more detail? I'm also interested in implementing this on a Windows 2003 server where I'm running a website off IIS.
02-28-2010, 05:32 AM
It's extremely simple. Simply create a vbs file:
mysqlquery (select from members where whatever)
Go to your window scheduler and schedule that file to run daily, weekly, etc.
02-01-2014, 08:55 AM
Hoping people are still reading this thread... I tried the below "simpleton" code and it seems to be doing nothing. When I pop this into an ASP page and load it with a browser, it works fine, but not as a .vbs file just opened from a satelllite computer. Do I need to have it be opened on the server itself?