Insert Into errorLog ( errorStamp, errorDetail, errorBase64, errorType, template, queryString, browser, remoteAddr, httpReferer, application, server, scriptName ) VALUES ( #CreateODBCDateTime(error.DateTime)#, '#left(trim(error.diagnostics),2200)#', '#Trim(Left(ToBase64(error.diagnostics),3000))#', '#errorType#', '#error.template#', '#error.queryString#', '#error.browser#', '#error.RemoteAddress#', '#error.HTTPReferer#', '#application.applicationName#', '#cgi.server_name#', '#CGI.SCRIPT_NAME#' ) Allen [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <1131419977.598992.116190@g47g2000cwa.googlegroups.com> [ref] => [htmlstate] => on_nl2br [postusername] => criticalim@hotmail.com [ip] => criticalim@hotm [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 3 [islastshown] => 1 [isfirstshown] => [attachments] => [allattachments] => ) --> error reporting - Coldfusion - Advanced Techniques
Professional Web Applications Themes

error reporting - Coldfusion - Advanced Techniques

Is there a way in CF7 when an error is generated by a user that they not only receive my "site-wide" error handler but it also would enter that error in to a database table or maybe send me an email? Much obliged...

  1. November 7th, 10:34 PM #1

    Default error reporting

    Is there a way in CF7 when an error is generated by a user that they not only
    receive my "site-wide" error handler but it also would enter that error in to a
    database table or maybe send me an email?

    Much obliged

    glossen Guest
  2. November 7th, 11:56 PM #2

    Default Re: error reporting

    You can get an email. See the http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Doentation&file=0 0000242.htm.

    Ted Zimmerman
    tzimmerman Guest
  3. November 8th, 03:19 AM #3

    Default Re: error reporting

    Here is a routine that I include in my SiteWide error handler to log
    the eror into a database.

    <cfif Left(trim(error.diagnostics),4) is 'ODBC' OR
    Left(trim(error.diagnostics),5) IS 'OLEDB' OR
    Left(trim(error.diagnostics),30) is 'Error Executing Database Query'>
    <cfset errorType = "Database Error">
    <cfelseif Left(trim(error.diagnostics),17) is 'Request timed out'>
    <cfset errorType = "Request Timeout">
    <cfelseif error.diagnostics contains 'Error resolving parameter'>
    <cfset errorType = "Error Resolving parameter">
    <cfelseif error.diagnostics contains 'Error resolving parameter
    <B>SESSION.'>
    <cfset errorType = "Session Timeout">
    <cfelseif Left(trim(error.diagnostics),53) is '<P>An error occured
    while evaluating the expression:'>
    <cfset errorType = "Error Evaluating Expression">
    <cfelseif Left(trim(error.diagnostics),30) is 'Just in time compilation
    error'>
    <cfset errorType = "Compilation Error">
    <cfelse>
    <cfset errorType = "Other Error">
    </cfif>
    <!--- <cfoutput>#errorType#</cfoutput> --->
    <cfquery name="InsertLogRecord" Datasource="#DataSource#">
    Insert Into errorLog
    (
    errorStamp,
    errorDetail,
    errorBase64,
    errorType,
    template,
    queryString,
    browser,
    remoteAddr,
    httpReferer,
    application,
    server,
    scriptName
    )
    VALUES
    (
    #CreateODBCDateTime(error.DateTime)#,
    '#left(trim(error.diagnostics),2200)#',
    '#Trim(Left(ToBase64(error.diagnostics),3000))#',
    '#errorType#',
    '#error.template#',
    '#error.queryString#',
    '#error.browser#',
    '#error.RemoteAddress#',
    '#error.HTTPReferer#',
    '#application.applicationName#',
    '#cgi.server_name#',
    '#CGI.SCRIPT_NAME#'
    )
    </cfquery>

    Allen

    criticalim@hotmail.com Guest
« dates from mysql | Table losing Records »

Similar Threads

  1. Error reporting in CGI
    By daniel kaplan in forum PERL Modules
    Replies: 2
    Last Post: May 20th, 02:05 PM
  2. Elegant error reporting, possible?
    By steve in forum PHP Development
    Replies: 5
    Last Post: March 15th, 02:57 AM
  3. error reporting
    By travis in forum PHP Development
    Replies: 11
    Last Post: October 17th, 02:42 PM
  4. Error Reporting
    By Rohit in forum Windows XP/2000/ME
    Replies: 2
    Last Post: July 28th, 12:06 AM

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
  •  

Forum Rules


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