Auto eamil from FP 2000 web

[klxdrt]

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.

Does anyone know of any javascripts, dhml, etc. that I could insert with that job posting to send me an email stating job posting #16 expires... or whatever?

Thanks,

Herb

PS: came across these 2 sites and thought the group may be interested: www.bootdisk.com
www.overclockersforum.com

[awasson]

Hi herb.......

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.

Andrew

[bud]

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.

or

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.