RE: cftry and cfcatch

[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:

<cftry> 

        <!--- Set the variable for your second issue here. --->
        <cfset notRunQuery = 0 >
        <cfset problemQueryNumber = 0>
        
 <cftry>        
        <cfstoredproc name="checksrv" datasource="master"
returnCode="YES" result="storedProc1Return">
                SELECT @@SERVICENAME;
        </cfstoredproc>


 <cfcatch type = "database">

        <cfset notRunQuery = notRunQuery + 1 >
        <cfset problemQueryNumber = 1>

        <cfthrow type = "yourOwnError">
                
 </cfcatch>
        
 </cftry>

 <cftry>                        
        <cfstoredproc name="checkage" datasource="master"
returnCode="YES" result="storedProc2Return">
                SELECT count (program_name)
                FROM master.dbo.sysprocesses
                WITH (NOLOCK)
                WHERE program_name LIKE '%Agent%'
        </cfstoredproc>


 <cfcatch type = "database">
        
        <cfset notRunQuery = notRunQuery + 1 >
        <cfset problemQueryNumber = 2>
        
        <!--- Throw your own error for the outermost cfcatch to catch
--->
        <cfthrow type = "yourOwnError">

 </cfcatch>

 </cftry>

 <cfcatch type ="yourOwnError">

        <cfif notRunQuery is 2>
        
         <!--- Send "MSSQLSERVER Not Avail and Agent Not Avail" in
cfmail. --->
        
      <cfelseif notRunQuery is 1>
                <cfif problemQueryNumber = 1> 
                        <!--- Send "MSSQLSERVER Not Avail" in cfmail.
--->
                <cfelseif problemQueryNumber = 2>
                         <!--- Send "Agent Not Avail" in cfmail. --->
                </cfif>
        </cfif> 
        
 </cfcatch>             
</cftry>

<!--- 
                Check the errors(return values) with from two stored
procedures.             
                Do CFMail here by checking two return structs
("storedProc1Return and storedProc2Return") 
--->



HTH,

Pine

-----Original Message-----
From: John Lucania [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, February 07, 2006 6:00 PM
To: CF-Talk
Subject: cftry and cfcatch


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 checksrv doesn't return "MSSQLSERVER"
         then,  "MSSQLSERVER not returned" in cfmail
or
query checkage doesn't return 2
         then, "Agent not returned 2" in cfmail
or
both of checksrv and checkage  don't return
         then, "MSSQLSERVER not returned and Agent not returned 2" in
cfmail or

2)
query checksrv cannot be run
         then, "MSSQLSERVER Not Avail" in cfmail
or
query checkage cannot be run
         then, "Agent Not Avail" in cfmail
or
both of checksrv and checkage cannot be run
         then, "MSSQLSERVER Not Avail and Agent Not Avail" in cfmail.

Any ideas?

tia,

jl



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231649
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54