Re: [ACFUG Discuss] Problems with Errors and Quotes

2011-03-15 Thread Steve Ross
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

RE: [ACFUG Discuss] Problems with Errors and Quotes

2011-03-15 Thread DeJong, Nathan D.
Try replacing the quote with its HTML entity: Replace(Error.Diagnostics, , quot;, all) Thanks, Nathan DeJong Applications Developer Oxford College of Emory University nathan.dej...@emory.edumailto:nathan.dej...@emory.edu 770-784-4662 From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of

Re: [ACFUG Discuss] Problems with Errors and Quotes

2011-03-15 Thread Douglas Knudsen
also to note,CFQUERYPARAM, which you should certainly be using, handles mixed quotes and single ticks on DB insert/updates. In the past I have trapped Error.Diagnostic along with other Error properties into a DB table. I then had a scheduled job running a nightly error report as well as a job

RE: [ACFUG Discuss] Problems with Errors and Quotes

2011-03-15 Thread Matthew Nicholson
Thank you all for the excellent suggestions! I think my first problem was that I simply was following what was built into the system initially. (Which was basically nothing and bad handling of the errors.) I had a feeling this was being way more difficult than necessary, I'll see what I

RE: [ACFUG Discuss] Problems with Errors and Quotes

2011-03-15 Thread Charlie Arehart
Matthew, as for that original approach you found, it likely stemmed from primordial days when CFERROR could NOT point to a CFM page that did things like CFMAIL. I could only point either to an HTML page or a CFML page with very limited functionality (it could output variables to the screen and

Re: [ACFUG Discuss] Problems with Errors and Quotes

2011-03-15 Thread Clint Willard
#'s ;) cfsavecontent var=the_error cfdump var=#cfcatch# /cfsavecontent *Clint Willard * Senior ColdFusion Architect Palm Coast Data clint...@gmail.com On Tue, Mar 15, 2011 at 8:37 AM, Steve Ross nowhid...@gmail.com wrote: To expand on what troy said: cfsavecontent var=the_error cfdump