Hi,
I was using the production version of my pages tonight and got an error that
should have been caught before I sent it live.
<cfif session.thisuser eq 1229>
<cfdump var="#Resultz#" label="Resultz" expand="false" />
</cfif>
Okay I have fixed the problem but don't know why it didn't trigger my error
function in application.cfc and showed the CF error message with all the debug
information rather than my error page.
<cffunction name="onError" returnType="void" output="true">
<cfargument name="exc" required="true" />
<cfargument name="eventName" type="string" required="true" />
<cfset var iErrorLogID = 0/>
<cfset debugstart = ''>
<!--- <cfinclude template="error.cfm"> --->
<cfset ErrorReport = {
AppName = this.name,
Type = arguments.exc.Type,
Message = arguments.exc.message,
ExceptionType = arguments.exc.TagContext[1].type,
TemplatePage = arguments.exc.TagContext[1].template,
ErrorLine = arguments.exc.TagContext[1].line,
ErrorColumn = arguments.exc.TagContext[1].column,
ErrorDetail = arguments.exc.detail,
DataSource = this.dsn,
ErrorCode = 0,
QuerySQL = '',
QueryError = '',
QueryWhere = '',
Places = 'Error Locations:<br>',
UserID = session.thisuser
}>
<cfsavecontent variable="content">
<h2>Error Report: #DateFormat(Now(),"long")#,
#TimeFormat(Now(),"long")#</h2>
<h3 style="color:red;" id="errormessage">#arguments.exc.Type#
#arguments.exc.message#</h3>
<h4 style="color:blue;" id="errorlocation">The
#arguments.exc.TagContext[1].type# error occurred in
#arguments.exc.TagContext[1].template#</h4>
<p id="errordetail">Detail:#arguments.exc.detail#</p>
<cfswitch expression="#arguments.exc.Type#" >
<cfcase value="Database">
<cfset ErrorReport.DataSource = arguments.exc.DataSource />
<cfset ErrorReport.ErrorCode =
arguments.exc.NativeErrorCode />
<cfset ErrorReport.QuerySQL = arguments.exc.SQL />
<cfset ErrorReport.QueryError = arguments.exc.QueryError />
<cfset ErrorReport.QueryWhere = arguments.exc.Where />
<p id="errordsn">Data Source: #arguments.exc.DataSource#
#arguments.exc.NativeErrorCode#</p>
<p id="errorsql">SQL:#arguments.exc.sql#</p>
<p id="errorquery">Query
Error:#arguments.exc.queryError#</p>
<p id="errorwhere">Where Clause:#arguments.exc.where#</p>
</cfcase>
<cfcase value="Expression">
<p id="errorquery">Error
Number:#arguments.exc.ErrNumber#</p>
</cfcase>
<cfcase value="Application">
<p id="ExtendedInfo">Extended
Info:#arguments.exc.ExtendedInfo#</p>
</cfcase>
<cfcase value="lock">
<p id="Lock">Lock
#arguments.exc.LockName#:#arguments.exc.LockOperation#</p>
</cfcase>
</cfswitch>
<cfloop from="1" to="#ArrayLen(arguments.exc.TagContext)#" index="i">
<cfset ErrorReport.Places &= "Page: " &
arguments.exc.TagContext[i].Template />
<cfset ErrorReport.Places &= 'Line: ' &
arguments.exc.TagContext[i].Line & ':' />
<cfset ErrorReport.Places &=
arguments.exc.TagContext[i].Column & chr(13) />
</cfloop>
<cfoutput>#ErrorReport.Places#</cfoutput>
<cfdump var="#ErrorReport#">
<cfdump var="#exc#">
</cfsavecontent>
<cfquery name="InsertErrorRecord" datasource="#this.dsn#"
result="QueryResultz">
Insert into ErrorTrapper(AppName,Type,
Message,ExceptionType,
TemplatePage,ErrorLine,ErrorColumn,ErrorDetail,
DataSource,ErrorCode,QuerySQL,QueryError,QueryWhere,
Places, UserID)
values (<cfqueryparam value="#ErrorReport.AppName#"
cfsqltype="cf_sql_varchar" />
,<cfqueryparam
value="#ErrorReport.Type#" cfsqltype="cf_sql_varchar" />
,<cfqueryparam
value="#ErrorReport.Message#" cfsqltype="cf_sql_varchar" />
,<cfqueryparam
value="#ErrorReport.ExceptionType#" cfsqltype="cf_sql_varchar" />
,<cfqueryparam
value="#ErrorReport.TemplatePage#" cfsqltype="cf_sql_varchar" />
,<cfqueryparam
value="#ErrorReport.ErrorLine#" cfsqltype="cf_sql_numeric" />
,<cfqueryparam
value="#ErrorReport.ErrorColumn#" cfsqltype="cf_sql_numeric" />
,<cfqueryparam
value="#ErrorReport.ErrorDetail#" cfsqltype="cf_sql_varchar" />
,<cfqueryparam
value="#ErrorReport.DataSource#" cfsqltype="cf_sql_varchar" />
,<cfqueryparam
value="#ErrorReport.ErrorCode#" cfsqltype="cf_sql_numeric" />
,<cfqueryparam
value="#ErrorReport.QuerySQL#" cfsqltype="cf_sql_varchar" />
,<cfqueryparam
value="#ErrorReport.QueryError#" cfsqltype="cf_sql_varchar" />
,<cfqueryparam
value="#ErrorReport.QueryWhere#" cfsqltype="cf_sql_varchar" />
,<cfqueryparam
value="#ErrorReport.Places#" cfsqltype="cf_sql_varchar" />
,<cfqueryparam
value="#ErrorReport.UserID#" cfsqltype="cf_sql_integer" />)
</cfquery>
<cfset iErrorLogID = QueryResultz.generated_key />
<cfset Session.LastError = iErrorLogID />
<cfinclude template="error.cfm">
<cfmail to="[EMAIL PROTECTED]" from="[EMAIL PROTECTED]"
username="[EMAIL PROTECTED]"server="******.com"
type="html"
subject="JSL Error #iErrorLogID#
#arguments.exc.message#" failto="[EMAIL PROTECTED]">
<cfoutput>
#content#
</cfoutput>
</cfmail>
</cffunction>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310599
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
