Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: Mail after database is updated


    I have the following problem:

    Swing application has a function which allows user to updated the status of a field (holiday status to be exact).

    Now when this field is updated I would like that an e-mail is sent to that employee to inform his of his new status.

    Please help me !!!


  2. #2
    Join Date
    Aug 2003
    you can use a trigger for check update of the field,
    next write a field with [mail-date] in other table.

    now write a daemon that check this table every n minutes;
    1-read from table.
    2-send emails.
    3-delete from table.

Posting Permissions

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