Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5

Thread: Email alerts

  1. #1
    New to the CF scene
    Join Date
    Aug 2003
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Email alerts

    Hi guys,

    I am building a database for a recruitment site. Everything is going great. Admin section is nearly there. Searching the database is finished, but the client has just asked me if it was possible to set it up so a user can enter his/her email address and the kind of job they are interested in. When the client enters a new job, if it matches what someone is looking for eg Business, there will be an automatic email alert to that person. Kinda like here http://www.daft.ie/emailalerts.daft

    I have no idea how to do this. Any suggestions/apps out there?

    Thanks in advance.

  • #2
    Senior Coder A1ien51's Avatar
    Join Date
    Jun 2002
    Location
    Between DC and Baltimore In a Cave
    Posts
    2,717
    Thanks
    1
    Thanked 94 Times in 88 Posts
    Basically you need a database with the search paramters, when you add the job, you need to loop through the table and see if anny of them match keywords in the new posting. Then send out an email if there is a match.


    What part are you not sure about?

    Eric
    Tech Author [Ajax In Action, JavaScript: Visual Blueprint]

  • #3
    New to the CF scene
    Join Date
    Aug 2003
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    This bit here:

    "you need to loop through the table and see if anny of them match keywords in the new posting. Then send out an email if there is a match."


    How do i go about doing this?

  • #4
    Senior Coder A1ien51's Avatar
    Join Date
    Jun 2002
    Location
    Between DC and Baltimore In a Cave
    Posts
    2,717
    Thanks
    1
    Thanked 94 Times in 88 Posts
    All it is a sql query and you need to loop through all of the results..

    http://www.codeave.com/asp/code.asp?u_log=56

    shows how to write a table from a query.


    Instead of writing a table, you want to use a email script to send out emails.

    Eric
    Tech Author [Ajax In Action, JavaScript: Visual Blueprint]

  • #5
    New to the CF scene
    Join Date
    Aug 2003
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you. I will try and see if I can get that working.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •