Try replacing the quote with its HTML entity: Replace(Error.Diagnostics, """", """, "all")
Thanks, Nathan DeJong Applications Developer Oxford College of Emory University [email protected]<mailto:[email protected]> 770-784-4662 From: [email protected] [mailto:[email protected]] On Behalf Of Steve Ross Sent: Tuesday, March 15, 2011 8:37 AM To: [email protected] Subject: Re: [ACFUG Discuss] Problems with Errors and Quotes 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 <[email protected]<mailto:[email protected]>> wrote: I'd just dump the cfcatch structure in cfmail or cferror if done through an error handling script, as John suggests. [da_logo_70x263] ___________________________________________________________________________________________ Troy Jones | Developer/Support Technician | Dynapp Inc | 1-800-830-5192<tel:1-800-830-5192> ext. 603 | dynapp.com<http://www.dynapp.com/> | facebook.com/dynapp<http://www.facebook.com/dynapp> From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of John Youngman Sent: Monday, March 14, 2011 6:07 PM To: [email protected]<mailto:[email protected]> 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" <[email protected]<mailto:[email protected]>> 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 -- Steve Ross web application & interface developer http://blog.stevensross.com [mobile] (912) 344-8113 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] ________________________________ This e-mail message (including any attachments) is for the sole use of the intended recipient(s) and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this message (including any attachments) is strictly prohibited. If you have received this message in error, please contact the sender by reply e-mail message and destroy all copies of the original message (including attachments). ------------------------------------------------------------- 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 http://www.fusionlink.com -------------------------------------------------------------
<<inline: image001.jpg>>
