Error parameters when it's a database error question.

[DURETTE, STEVEN J (ATTASIAIT)]

All,

 

I have a custom error template that emails me quite a bit of info
whenever there is a problem, however I'm not getting all the information
I want.

 

I know that if you dump or display/email #error.rootcause.SQL#, it
displays the sql code as it should. But it puts things like (param 1)
where there would be a value passed in (happens with using
cfqueryparam).  I looked up that if I dump or display/email
#error.where# I should get what those (param) items are, but I never get
any results from error.where.

 

I would really like to know what these values are because they really
help with troubleshooting.

 

Any ideas?

 

Steve

 



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328097
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4

[Barney Boisvert]

I just blogged about this a week or two ago, actually:

http://www.barneyb.com/barneyblog/2009/10/29/fixing-cf-db-error-messages/

The field you want is "where" (a peer of "sql").

cheers,
barneyb

On Fri, Nov 6, 2009 at 11:21 AM, DURETTE, STEVEN J (ATTASIAIT)
<sd1985@...> wrote:

>
> All,
>
>
>
> I have a custom error template that emails me quite a bit of info
> whenever there is a problem, however I'm not getting all the information
> I want.
>
>
>
> I know that if you dump or display/email #error.rootcause.SQL#, it
> displays the sql code as it should. But it puts things like (param 1)
> where there would be a value passed in (happens with using
> cfqueryparam).  I looked up that if I dump or display/email
> #error.where# I should get what those (param) items are, but I never get
> any results from error.where.
>
>
>
> I would really like to know what these values are because they really
> help with troubleshooting.
>
>
>
> Any ideas?
>
>
>
> Steve
>

--
Barney Boisvert
bboisvert@...
http://www.barneyb.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328098
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4