View Full Version : Auto eamil from FP 2000 web
05-09-2002, 11:08 AM
I maintain a website that contains a small job mart and I am looking for a "script" that will send me a simple email when the job posting expires.
PS: came across these 2 sites and thought the group may be interested: www.bootdisk.com
05-24-2002, 06:29 PM
You'll have to delve into the dirty world of ASP and database coding to do it, but I'm sure it's do-able...... Maybe even use a custom VB component to do the trick.
You would need some sort of program ASP, or VB or dot.net that would query the job database and create a list of jobs expiring for that date, then it would create a mail object and fire of a report.
I haven't ever built such an animal, but it seems quite do-able.
Problems with such an animal...
Needs to run as a service. This way a standard query can be performed at a specified time (Works on any ODBC compliant DB).
On NT/2000 this would involve writting a ISAPI filter.
SQL does have the ability to run predefined tasks on a scedule. Access does not.
MySql on Unix based systems, I think Robert would be able to answer that one.
Another option would be to have a query run every time your home page gets a hit.
Powered by vBulletin® Version 4.1.12 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.