RE: CFTRY and CFCATCH

2005-10-10 Thread Dawson, Michael
Try CFDUMP on the CFCATCH structure. That should show you the type of the exception. ...SQL... I would say, in this case, it is probably a database exception. M!ke -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Monday, October 10, 2005 7:21 AM T

RE: cftry and cfcatch

2006-02-08 Thread PINE Phyo Z
I'm guessing here but I think your two queries are using stored procedures. So, use cfstoredproc to check the return values. Then, your first issue will be resolved. Then use nested cftry and cfcatch for each stored proc to resolve the second issue. So probably something like this:

RE: cftry and cfcatch

2006-02-08 Thread PINE Phyo Z
ssage- From: PINE Phyo Z Sent: Wednesday, February 08, 2006 8:53 AM To: 'cf-talk@houseoffusion.com' Subject: RE: cftry and cfcatch I'm guessing here but I think your two queries are using stored procedures. So, use cfstoredproc to check the return values. Then, your first issue

Re: cftry and cfcatch

2006-02-08 Thread John McKown
Sounds like you do not want TRY/CATCH... that is triggered on a failure. You really want to use CFSWITCH/CFCASE. -- John McKown President, Delaware.Net ICQ: 1812513 We host Fusebox.org and all of our apps are Fusebox/ColdFusion/BlueDragon compliant. John Lucania wrote: >I have two queries:

Re: cftry and cfcatch

2006-02-25 Thread John Lucania
Thank you so much, Pine et al. It works wonderful. jl On 2/8/06, John McKown <[EMAIL PROTECTED]> wrote: > Sounds like you do not want TRY/CATCH... that is triggered on a failure. > You really want to use CFSWITCH/CFCASE. > > > -- > > John McKown > President, Delaware.Net > ICQ: 1812513 > We host