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 that did a error count, if a spike in errors occurred, we all got a SMS.
Douglas Knudsen http://www.cubicleman.com this is my signature, like it? On Tue, Mar 15, 2011 at 9:00 AM, DeJong, Nathan D. <[email protected]>wrote: > Try replacing the quote with its HTML entity: > > Replace(Error.Diagnostics, """", """, "all") > > > > Thanks, > > > > Nathan DeJong > > Applications Developer > > Oxford College of Emory University > > [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]> 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>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]] *On Behalf Of *John > Youngman > *Sent:* Monday, March 14, 2011 6:07 PM > *To:* [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]> 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 ] > > ------------------------------ > > 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 FusionLink <http://www.fusionlink.com> > ------------------------------------------------------------- >
<<image001.jpg>>
