I have a situation where a dynamic site is unavailable late at night during a database backup. I want to detect this condition and have ColdFusion tell the site visitor what's going on. Right now I'm just running a simple query in a CFTRY block against the database and then looking for the presence of (or content in) the CFCATCH.message variable. If it's there, they see explanatory text regarding the delay during the backup. However, I thought I remembered seeing a more sophisticated way to test for the existence of a functioning database connection. Can't find it now. Any tips? We're using CF5.
Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. --- [This E-mail scanned for viruses by Declude Virus] ========================================================= Kansas City ColdFusion User Group's website & listserv is hosted through the generous support of Clickdoug.com To send email to the list, email [EMAIL PROTECTED] To subscribe or unsubscribe, send an email to [EMAIL PROTECTED] with your request. For hosting solutions http://www.clickdoug.com Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1. ======================================================
