You can always upload to a second DB, then switch your app to the new DB. This will enable you to unwind if necessary and will diminish you site down-time.
Andy -----Original Message----- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:42 PM To: CF-Talk Subject: RE: A Tip (maybe new, maybe not) Might be dangerous Question Is there any way to disconnect from a database programmatically? Answer This is possible, but not recommended, especially if it is a multi-user database. To do so, however, clear the cached connection information with the following code: <cfset temp = cfusion_dbconnections_flush()> This code flushes all connection information from the cache, but it does not disconnect any actively running requests. -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 1:25 PM To: CF-Talk Subject: Re: A Tip (maybe new, maybe not) Even slicker .... thanks! Paul Giesenhagen QuillDesign > There is an undocumented CF Function that will do the same thing. > > CFUSION_DBCONNECTIONS_FLUSH() > > I used to use the bogus query to do this as well until I found out about > this function. > > Cheers! > > -- > Scott Van Vliet > Sempra Energy > 555 W. 5th St., 21st Floor > Los Angeles, CA 90013 > Tel > 213.244.5205 > Email > [EMAIL PROTECTED] > > "Hello Stupid, and welcome to your crappy computer." > - Strong Bad, HomestarRunner.com > > > > > > > > -----Original Message----- > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, May 16, 2002 9:32 AM > > To: CF-Talk > > Subject: A Tip (maybe new, maybe not) > > > > > > I don't know if any of you work with Access much as a > > database here and there, but I have been developing using an > > access database and had to upload it to our servers after > > "looking" at the data or correcting the data as I was writing > > scripts ..well as you all know it locks so you cannot FTP > > over it once it has been accessed. > > > > I would stop/start the cf service to get this to run, well it > > became a pain when my terminal window would timeout and I > > would have to logg back into my server yadda yadda. > > > > If you send a bogus query (one with an error), CF or Access > > will 'unlock' the file for you... and you are back in FTP business. > > > > Many of you might already know this .. but we just figured it > > out and I thought it was pretty slick! > > > > Paul Giesenhagen > > QuillDesign > > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists