Keith, There's a page in the docs about cf admin and its "undocumented" functions it uses...one such is:
CF_ISCOLDFUSIONDATASOURCE() -- Verifies a connection to a ColdFusion data source I think this is used in the "verify" button in the dsn pages...maybe this will help.....keep in mind, I took this from 4.5 so it may be n/a for CF5, but I thought i'd mention it. Thanks, Robert ----- Original Message ----- From: "Keith Purtell" <[EMAIL PROTECTED]> To: "KCFusion (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, December 09, 2003 4:21 PM Subject: [KCFusion] Checking for database availability > 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. > ====================================================== > ========================================================= 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. ======================================================
