The hosting provider for one of my clients is planning some down-time for their SQL Server. During that down-time, the web site will be completely useless. I'm looking for a way to avoid staying up past midnight to change the home page, and then change it back. Is there a way to detect whether or not the database is available, and display an alternate home page if it is not? My first thought was to use CFTRY / CFCATCH blocks around a query on the home page. If it fails display the 'site not available message.' However, there are no queries (or other database access) on the home page, so that is not an option. Any other ideas? It seems like it would be inefficient to add a query just for the sake of checking the database existance. Jeffry Houser | mailto:[EMAIL PROTECTED] AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781 -- Instant ColdFusion 5.0 | ISBN: 0-07-213238-8 Due out June 2001 -- DotComIt, LLC database driven web data using ColdFusion, Lotus Notes/Domino -- Far Cry Fly, Alternative Folk Rock http://www.farcryfly.com | http://www.mp3.com/FarCryFly -- I've been vindicated, I've been loved and hated I've been pulled aside and told that I was overrated ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
