Every once in a while our database server will be down, but the website server is fine. However, without a database, our application
\nis not very useful. So I use this little snippet to output a custom message. I use one for each datasource at the beginning of our app with an appropriate error message. CF8 has even more robust messaging capability for cfcatch if you want more.<\/p>\n
Every once in a while our database server will be down, but the website server is fine. However, without a database, our application is not very useful. So I use this little snippet to output a custom message. I use … Continue reading <cftry>
\n <cfquery name=\"dbcheck\" datasource=\"myDSN\">
\n select top 5 * from TABLE
\n <\/cfquery>
\n <!--- specify the type of error for which we search --->
\n <cfcatch type = \"Database\">
\n <cfif #cfcatch.message# contains 'Error'>
\n <!--- the message to display --->
\n <p style=\"color: red\">The application database is not avalilable.
\n <br \/> Please try again in a few minutes. <\/p>
\n <cfabort>
\n <\/cfif>
\n <\/cfcatch>
\n<\/cftry><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"