just do it when you usually have the least traffic.
adding a column would take under a minute
Bud <[EMAIL PROTECTED]> wrote:
On 12/14/00, W Luke penned:
>I have a small change to make to a live database (create a new column in a
>table) which is in Access. I don't really want to download it and upload it
>again, as I will undoutedly lose data (or visitors will get an error). So I
>was wondering what people's experiences are of this kind of situation and
>how best to handle it.
I usually place a generic block of code inside a cfif tag in my
application.cfm:
<CFPARAM NAME="attributes.maintenance" DEFAULT="">
<CFPARAM NAME="attributes.when" DEFAULT="">
<CFIF attributes.maintenance IS "yes">
<html>
<title>Undergoing Maintenance</title>
<body bgcolor=white>
<h2 align=center>Undergoing Maintenance</h2>
<div align=center>
We expect to be back online <cfoutput>#attributes.when#</cfoutput><br>
Please try then. We are sorry for the inconvenience.<p>
<a href="index.html">Home</a>
</div>
</body>
</html>
<cfabort>
</CFIF>
Then I can just add "yes" and "within several minutes." or "by 10 PM
EST." to the cfparam tags.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
