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 and all of our apps are Fusebox/ColdFusion/BlueDragon > compliant. > > > > John Lucania wrote: > > >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:233475 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