I'd just dump the cfcatch structure in cfmail or cferror if done through an error handling script, as John suggests.
[cid:image001.jpg@01CBE294.17A35B50] ___________________________________________________________________________________________ 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<mailto: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<http://www.avg.com> Version: 10.0.1204 / Virus Database: 1498/3506 - Release Date: 03/14/11
<<inline: image001.jpg>>
