To expand on what troy said:

<cfsavecontent var="the_error">
<cfdump var="cfcatch">
</cfsavecontent>

then mail "the_error"

On Mon, Mar 14, 2011 at 10:06 PM, Troy Jones <t...@dynapp.com> wrote:

> I'd just dump the cfcatch structure in cfmail or cferror if done through an
> error handling script, as John suggests.
>
>
>
> [image: da_logo_70x263]*
> **
> ___________________________________________________________________________________________
> **
> *
> *Troy Jones*  |  Developer/Support Technician  |  Dynapp Inc  |
> 1-800-830-5192  ext. 603  |  dynapp.com <http://www.dynapp.com/>  |
> facebook.com/dynapp <http://www.facebook.com/dynapp>
>
>
>
> *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *John
> Youngman
> *Sent:* Monday, March 14, 2011 6:07 PM
> *To:* discussion@acfug.org
> *Subject:* Re: [ACFUG Discuss] Problems with Errors and Quotes
>
>
>
> 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 <http://www.fusionlink.com>
> -------------------------------------------------------------
>
> ------------------------------
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1204 / Virus Database: 1498/3506 - Release Date: 03/14/11
>



-- 
Steve Ross
web application & interface developer
http://blog.stevensross.com
[mobile] (912) 344-8113
[ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ]

<<image001.jpg>>

Reply via email to