sql method in cfcatch

2010-04-28 Thread fun and learning

Hi All -

I am using try/catch around a cfquery. When I am trying to output #cfcatch.sql# 
or #cfcatch.where#, I get an error that SQl or where is undefined in cfcatch. 
These two used to work for me before. I have no issues with cfcatch.message or 
cfcatch.detail.

Can anyone let me know what could be the issue?



~|
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:333193
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: sql method in cfcatch

2010-04-28 Thread Barney Boisvert

The error you're catching might not have those properties.  For
example, maybe it's a connection failure error.  Or perhaps an
expression error in a CFQUERYPARAM.  Those keys will be present when
appropriate, but they're not necessarily available all the time.  As
such, you have to do existence checks before you use them.

cheers,
barneyb

On Wed, Apr 28, 2010 at 1:11 PM, fun and learning
funandlrnn...@gmail.com wrote:

 Hi All -

 I am using try/catch around a cfquery. When I am trying to output 
 #cfcatch.sql# or #cfcatch.where#, I get an error that SQl or where is 
 undefined in cfcatch. These two used to work for me before. I have no issues 
 with cfcatch.message or cfcatch.detail.

 Can anyone let me know what could be the issue?



 

~|
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:333197
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm