Jeffry,
I have a table with one entry... I have a program once per minute try
to fetch it... if it can't then it spawns notification...
likewise, it could simply set a server variable that would display an
out of service/maintenance message....
you could schedule an event to copy the homepage/pages prior to the
outage and then after the outage run another event to copy the original
files back....
just some ideas and how I would go about it... I don't have any code on
hand for such... Anyone else wrote such a beast yet?
-paris
[finding the future in the past, passing the future in the present]
[connecting people, places and things]
-----Original Message-----
From: Jeffry Houser <[EMAIL PROTECTED]>
Date: Wed, 06 Jun 2001 16:25:52 -0700
Subject: Semi-OT: Detecting whether or not the database is active..
>
> 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
