error checking

[yuchieh]

I need to check if the database server is down (our server has been flaky), then stop the insert process (coded in Cold Fusion).

How do I check the server?

Thanks

 

[mikeshort]

We do something like this:

<cftry>
   <cfquery name=&quot;avail&quot; datasource=&quot;DSN&quot;>
      SELECT 1 FROM DUAL
   </cfquery>
   <cfcatch type=&quot;database&quot;>
      do something because we didn't connect
   </cfcatch>
</cftry>

It works very nicely.

 

[yuchieh]

I have more than one insert query. Do I do this?

<cftry>
insert query1
insert query2
insert query3

<cfcatch type=&quot;database&quot;>
Do something here
</cfcatch>

</cftry>


Thanks for the reply.