Here's a tough problem, that I think may require scripting:
I have 2 databases: Jobs (job postings) and resumes (from job seekers). In both databases, the poster/seeker can check off items in a value list of what profession(s) the job listing (or seekers) applies to.
Here's the difficult part:
When the job poster submits a job, I would like the resumes database to be searched for anyone who has at least one of the job fields the poster checked off, and emailed with a form letter (using the email address in the resume listing).
There are a few key problems to this:
a - it's all CDML. All online, and I would like the search/email to be automatic.
b - I believe, since the search is a concatenated one on the value list, that the Find command is a multiple find, which I don't know if it is available through scripting, especially with dynamic values.
c - the email has to go through a web page to initiate the email function, as the server does not have an email client that can be queued.
ANY (and I do mean any) suggestions/help/ideas on this problem would be greatly appreciated. I don't want to have to resort to ASP, CGI, PHP, or any other language to learn.
By the way, I was planning to learn Lasso and modify the database, mainly for this functionality.
You can check out the database at www.ctjobs.com. If anyone has a solution, or would like the extra cash (if it is that difficult), let me know at dan@scheerdesign.com
Thanks in Advance (and thanks for reading this far!)
