[ACFUG Discuss] Problems with Errors and Quotes

[Matthew Nicholson]

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")



 

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 http://www.fusionlink.com

-

Re: [ACFUG Discuss] Problems with Errors and Quotes

[John Youngman]

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" 
 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")
> 
>  '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 
> -

RE: [ACFUG Discuss] Problems with Errors and Quotes

[Troy Jones]

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  |  
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" 
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")


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
-


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
<>