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
I have two queries:
SELECT @@SERVICENAME;
SELECT count (program_name)
FROM master.dbo.sysprocesses
WITH (NOLOCK)
WHERE program_name LIKE '%Agent%'
I want to be notified through cfmail if
1)
query checksrv doesn't return "MSSQLSERVER"
then, "MSSQLSERVER not returned" in cfmail
or
q
To: CF-Talk
Subject: CFTRY and CFCATCH
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
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
and
Agent Not Avail" in cfmail."
To resolve that, at the top of my head, just remove the 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, th
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
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.
">
Number of Bedrooms must have a value.">
">
">
My tags in my variable work but when i inserted the tag it hit some er
asic CFSET, 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.
form.PropertyDataCountry is "">
"Country must have a val
the color attribute in your font tags
>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
ic 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 -0500
>Stuart,
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
12 matches
Mail list logo