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 Fusebox.org
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:
cftry
in cfmail.
To resolve that, at the top of my head, just remove the cfthrow tags
in the cfcatch blocks. Handle it outside the cftry and cfcatch. I don't
think you would even need to nest the cftry anymore. So, the revised
version will be like this:
!--- Set the variable for your second 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:
I have two queries:
cfquery name=checksrv datasource=master
SELECT @@SERVICENAME;
/cfquery
cfquery name=checkage datasource=master
SELECT count (program_name)
FROM master.dbo.sysprocesses
WITH (NOLOCK)
WHERE program_name LIKE '%Agent%'
/cfquery
I want to be notified through cfmail if
1)
query
Hi All,
I have never really had a good handle on CFTRY and CFCATCH. If I have
an error on my website as follows
The request has exceeded the allowable time limit Tag: CFQUERY
What type of cfcatch is that? Or can that not be caught by CFCatch?
Mike
Try CFDUMP on the CFCATCH structure. That should show you the type of
the exception.
cftry
cfquery
...SQL...
/cfquery
cfcatch type=any
cfdump var=#cfcatch#
/cfcatch
/cftry
I would say, in this case, it is probably a database exception.
M!ke
-Original Message-
From
Hi,
I've a problem with CFSET, i'm trying to have a font color change in one of my statements but it doesn't seem to work.The CFSET is within a CFCATCH and CFTRY.
cfset MessageAlert = pThe following fields have errors:/p
cfif form.PropertyDataCountry is cfset MessageAlert = MessageAlert Country
, CFTRY and CFCATCH probs.
Hi,
I've a problem with CFSET, i'm trying to have a font color change in one
of my statements but it doesn't seem to work.The CFSET is within a
CFCATCH and CFTRY.
cfset MessageAlert = pThe following fields have errors:/p cfif
form.PropertyDataCountry is cfset
that's ending the set value too soon. Just leave out the quotes and try.
Greg
-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 11:59 AM
To: CF-Talk
Subject: basic CFSET, CFTRY and CFCATCH probs.
Hi,
I've a problem with CFSET, i'm trying
23, 2004 9:12 AM
To: CF-Talk
Subject: RE: basic CFSET, CFTRY and CFCATCH probs.
Thanks Greg, that's done it... just made them single ones.
-- Original Message --
From: Greg Luce [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Mon, 23 Feb 2004 12:04:44
Thanks for that Jevo! :-)
-Original Message-
From: J E VanOver [mailto:[EMAIL PROTECTED]
Sent: 23 February 2004 18:03
To: CF-Talk
Subject: RE: basic CFSET, CFTRY and CFCATCH probs.
FYI Stuart, you can also use a PAIR of double quotes in a CF string to
represent a quote.
In your
I just found, disappointingly enough that you can't have a cftry at the
top of a document via a CFinclude and the rest in another include at the
bottom? Is there a work around. I don't want to use a handler, and I want
the same error checking code on every page.
Please advise or throw ideas
you can do, is
include a cferror tag in your application.cfm tag or at the top of any
template containing CFTRY/CFCATCH/CFTHROW and wrap the rest of the page or
the code in question, with the CFTRY tags.
~Simon
Simon Horwith
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St
Alternately, you could have a main page that has a cftry/cfcatch block, and
include the meat of the page within (a la Fusebox). Worth a shot, neh?
--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC 28270
www.solutionmasters.com
704.563.5559 x 228 Voice
Haven't tried it but theoretically you might be able to:
application.cfm would contain: cf_error_check
onrequestend.cfm would contain: /cf_error_check
error_check.cfm would contain:
!--pseudo code--
if executionmode eq start
cftry cfcatch
else
/cfcatch/cftry
onrequestend.cfm
On 12/13/00, Neil H. penned:
I just found, disappointingly enough that you can't have a cftry at the
top of a document via a CFinclude and the rest in another include at the
bottom? Is there a work around. I don't want to use a handler, and I want
the same error checking code on every page.
don't want url parameters.
Thanks,
Neil
- Original Message -
From: "Bud" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, December 13, 2000 12:45 PM
Subject: Re: cftry cfcatch/cfcatch/cftry
On 12/13/00, Neil H. penned:
I just found, disappointingly e
Ok, you wanted a hint, here's big a hint. Obviously, the advantage to using
a global CFTRY/CFCATCH is that variables are still scoped in the exception
block, unlike the global exception handler. The open and close cftry (as
you said) must be in the same template, the solutions is surprisingly
i use a custom tag. the cftry are included in very page. so the custom tag
will perform what ever error handling required.
cftry
... codes ...
cfcatch type="any"
cf_errorhandler
/cfcatch
/cftry
-ken
- Original Message -
From: Neil H. [EMAIL PROTECTED]
Subject: cft
20 matches
Mail list logo