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

cftry and cfcatch

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

RE: CFTRY and CFCATCH

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

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 will be resolved. Then use nested cftry and cfcatch for each stored proc to resolve the second issue. So probably something like

RE: cftry and cfcatch

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

Re: cftry and cfcatch

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

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

basic 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. "> Number of Bedrooms must have a value."> "> "> My tags in my variable work but when i inserted the tag it hit some er

RE: basic CFSET, CFTRY and CFCATCH probs.

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

RE: basic CFSET, CFTRY and CFCATCH probs.

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

RE: basic CFSET, CFTRY and CFCATCH probs.

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,

RE: basic CFSET, CFTRY and CFCATCH probs.

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