Seems like CFMail goes wonky every once in a while and decides not to work. The administrators always blame it on too much mail for the server to handle. So I decided to call them on their “theory” and build a tracking tool.<\/p>\n
This is a simple tool that merely writes a record to a database every time that the CFMAIL tag is used. I track not only the date and time but the application(tool_name) that sent the mail. You can add your own elements.<\/p>\n
Step 1 – Create the tracker table Step 2 – Build the Component that will write the record to the table. Step 3 – Add the code to call the cfc. Seems like CFMail goes wonky every once in a while and decides not to work. The administrators always blame it on too much mail for the server to handle. So I decided to call them on their “theory” and build … Continue reading
\nCREATE TABLE dbo.CFMail_Tracker
\n(
\ntool_name char(20) NULL,
\nmail_date smalldatetime NULL
\n) <\/code><\/p>\n
\nmail_tracker.cfc <\/strong>
\n<cfcomponent>
\n<cffunction name=\"mailtrack\" access=\"public\" >
\n<cfargument name=\"tool_name\" type=\"string\" required=\"true\" default=\"NA\" \/>
\n<cfquery name=\"insrec\" datasource=\"bmprsql\">
\ninsert into CFMAil_Tracker
\nvalues ('#tool_name#', getDate())
\n<\/cfquery>
\n<\/cffunction>
\n<\/cfcomponent><\/code><\/p>\n
\nafter <\/cfmail>
\n<cfinvoke component=\"mail_tracker<\/em>\" method=\"mailtrack\" tool_name=\"tool name here<\/em>\" \/> *<\/code>
\n* You may have to adjust the path to your mail_tracker.cfc. <\/span>Tool name is the application name or descriptor you wish to track.<\/p>\n","protected":false},"excerpt":{"rendered":"