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
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:
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
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:
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
5 matches
Mail list logo