> I'd have to think that Disable Database Connections would also be
> immediate (but I'm honestly not sure). And while it may be more
> intrusive then momentarily unlocking the database with a bad query, if
> Rick's site is popular, disabling database connections to the db may be
> the only way to go because other users may relock the database before he
> can initiate / complete his upload. Similarly, if users try to query
> his database while he's uploading the database, they will receive an
> error.
...
> - Jay
ack .. I lapsed into the mindset of a database that doesn't need uploading
to update the DB structure. My bad :(
Todd
>
> -----Original Message-----
> From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 11:05 PM
> To: CF-Talk
> Subject: Re: Locked Database
>
>
> > Usually sending a bad query to the data source will break the lock.
> > You can also set "disable database connections" in the CF
> > Administrator. If you disable db connections, make sure you enable
> > them again, otherwise your site won't work :-)
>
> The bogus query is a better option .. it is less intrusive and more
> immediate than the "disable database connections" one. The other method
> I was refering to in my last post is the CFusion_DBConnections_Flush()
> function. That tends to break all DB connections without having to
> change anything on the CF server. To use it, set some temp variable to
the function .. .eg: <cfset Variables.uselessTempVariable
CFusion_DBConnections_Flush()>
>
> Todd
>
> > Jay Sudowski
> > ---------------------
> > Handy Networks LLC
> > TEL: 877-70-HANDY
> > FAX: 888-300-2FAX
> > URL: www.handynetworks.com <http://www.handynetworks.com>
> > ---------------------
> > Providing reseller and dedicated Windows 2000 web hosting solutions.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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