Could u not just use cfmail in a global error handler script?

Sent from my iPhone

On Mar 14, 2011, at 5:54 PM, "Matthew Nicholson" 
<matthew.nichol...@soltech.net> wrote:

> Evening All!
> 
>  
> 
> I’d love your thoughts on a sort of odd-ball problem.
> 
>  
> 
> Here’s the situation:
> 
>  
> 
> I’m attempting to capture all error messages generated from my code and then 
> send an email. I do this by passing all the information into an HTML form and 
> then shooting off a CFMail with all the necessary information in it.
> 
>  
> 
> Here’s the problem:
> 
>  
> 
> During this translation into HTML, text like this;
> 
>  
> 
> Error Executing Database Query. [Macromedia][SQLServer JDBC 
> Driver][SQLServer]The DELETE statement conflicted with the REFERENCE 
> constraint "FK_name". The conflict occurred in database "QA-tracker", table 
> "dbo.table", column 'column_id’. 
> The error occurred on line 131.
> 
>  
> 
> truly does a number on the HTML form and escapes out displaying a portion of 
> the error to the users.
> 
>  
> 
> I’ve tried the following to try to clean up this mess but have yet to find a 
> viable solution (or my syntax can be horrendously off… either way)
> 
>  
> 
> HTMLCodeFormat(Error.Diagnostics)
> 
> HTMLEditFormat(Error.Diagnostics)
> 
> Replace(Error.Diagnostics, " "" ", "", "All")
> 
> <CFSET variable = REReplaceNoCase(#Error.Diagnostics#, '[^[:alnum:]]', '', 
> 'all')>
> 
>  
> 
> Any thoughts or suggestions would be greatly appreciated at this point!
> 
>  
> 
> Thanks!
> 
>  
> 
> Matthew R. Nicholson
> 
> To find what you seek in the road of life, the best proverb of all is that 
> which says: "Leave no stone unturned."
>       ~Edward Bulwer Lytton
> 
>  
> 
> 
> ------------------------------------------------------------- 
> To unsubscribe from this list, manage your profile @ 
> http://www.acfug.org?fa=login.edituserform 
> 
> For more info, see http://www.acfug.org/mailinglists 
> Archive @ http://www.mail-archive.com/discussion%40acfug.org/  
> List hosted by FusionLink 
> -------------------------------------------------------------

Reply via email to