Professional Web Applications Themes

how to track emails - Coldfusion - Advanced Techniques

Hi does anyone knoow awa y to track emails sent via cfmail. thats is if email is opneend .forwarded etc. any help appreciated....

  1. #1

    Default how to track emails

    Hi does anyone knoow awa y to track emails sent via cfmail.
    thats is if email is opneend .forwarded etc.
    any help appreciated.

    noodleweb Guest

  2. #2

    Default Re: how to track emails

    >... to track emails sent via cfmail
    You could do that in your e-mail server
    BKBK Guest

  3. #3

    Default Re: how to track emails

    Are you just trying to keep track of the 'send' email address? or is this a
    security tracking setting?

    if it was a security tracking setting, I would create a table in your dB that
    keeps track of what was sent. You could have it do an insert for every use of
    the cfmail tag and keep it as simple or as detailed as you like. then you
    could have a report run that tracks specific user usage, high usage times, find
    an abuser, etc.

    coderWil Guest

  4. #4

    Default Re: how to track emails

    Create the table with fields [user_id], fromemail, toemail, subject, bodytext,
    sentdate (I have assumed you have a unique user_id associated to people
    allowed to use the mail form, if you don't, rethink your application as it is
    flawed)
    in your code (directly before or after each email is sent) add the insert
    <cfquery name="add" datasource="your dsn name">
    insert into [table name]
    (user_id,fromemail, toemail, subject, bodytext, sentdate)
    values
    (<cfqueryparam value="#[user_id]#">,<cfqueryparam
    value="#[var-fromemail]#">,<cfqueryparam value="#[var-toemail]#">,<cfqueryparam
    value="#[var-subject]#">,<cfqueryparam value="#[var-bodytext]#">, sysdate)
    </cfquery>


    The '[' and']' surrounding text indicates that you would change it to the
    variable name or value that matches your application.


    In your reporting page, you could select count from the fromemail address,
    from the toemail, etc to try to detect abuse. You can view the body of the
    emails to detect abusers, etc


    coderWil Guest

Similar Threads

  1. Track statistics
    By lilbuckeye in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: June 23rd, 11:42 AM
  2. How does flex keep track of changes?
    By *Ludwig* in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: February 18th, 10:41 AM
  3. Am I on the right track - timezones
    By Jon in forum PERL Miscellaneous
    Replies: 4
    Last Post: September 30th, 01:03 AM
  4. CD track editor for OS X?
    By Stephen in forum Mac Applications & Software
    Replies: 2
    Last Post: August 28th, 06:25 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139