Automated query results via CDONTS or ASPmail

[Kozimoto]

I'm searching for a way to send individualized emails to subscribers much the same way DICE.com, or any job listing site does, when a user selects their search criteria, saves the criteria to their profile, and chooses the frequency to receive "their job listings" each day, twice a week, etc., with links back to the site in the email for all records found.

I'm looking for code examples, MX extensions, or any solution that a mere mortal could implement, and have service run each day. Tips on how to automate this process would be great. And any insight on how much additional load on the server this type of script my generate would be appreciated as well.

Thanks for any and all replies!

 

[Bastien]

One way is to build the complete script and use either a CRON job or Task SCheduler in windows to run the script at certain times.

You will need to track what jobs the user had been emailed to ensure that you are not sending the same job to him repeatedly.

Its not that hard to build. You need a loop to build the user list and get the name and email and search criteria from the database. Then for each user, run a query to locate matching jobs. If the job is found, check the sent table to ensure its not a repeat, if not then build the email and add the jobID to the sent table. If it is a duplicate ignore it and move to the next record. Send the email.

Break it down into little steps and you'll find its makes itself easy to do

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!