SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    596
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Need database that can send emails based on a trigger

    Does anyone know?? Aside from Oracle and SQL Server?


    dlg

  2. #2
    What? Maelstrom's Avatar
    Join Date
    Oct 2001
    Location
    Whistler BC originally from Guelph Ontario
    Posts
    2,175
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Just using a db or including a db and a server sided language?
    Maelstrom Personal - Apparition Visions
    Development - PhP || Mysql || Zend || Devshed
    Unix - FreeBSD || FreeBsdForums || Man Pages
    They made me a sitepoint Mentor - Feel free to PM me or Email me and I will see if I can help.

  3. #3
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    596
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It really doesn't matter to me; however, database sided would be better than server side.

    PLEASE HELP!!

  4. #4
    SitePoint Member
    Join Date
    Jun 2002
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    create a script

    quite simple, create a field in the table marking wheather the email has been sent or not, and have a script constantly, (or periodically) re-iterate through the table sending all messages marked un-sent... if send is successfull then have it update the field in the table; eg:

    CREATE TABLE sendmsgs (
    ...
    hasbeensent ENUM('Y','N') NOT NULL DEFAULT 'N'
    ...
    );

  5. #5
    ********* Addict DLG_1's Avatar
    Join Date
    Jun 2000
    Location
    Texas, USA
    Posts
    596
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Talking

    Great! You've given me a great workaround to dumb databases that don't support email sends. all I need now is for MySQL to support triggers.

    so this "script" that I would write to periodically check the database table, what technology would I use? how? cron?

  6. #6
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    A simple PHP script would do it, just run it every X minutes (or whatever) with Cron or Task Scheduler on Windows

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature


Bookmarks

Posting Permissions

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