>My application is hosted with inhouse government hosting. Therefore I don't >have access to the CF server or easy access to my sites pages. The only >thing I have control over on a less than 4 week notice is uploading a new >database. (Flintstone-ville) > >However, there seems to always be a lock on the database (access 97) such >that I cannot upload when I want. I have created a dbunlock.cfm page to >upload (runs a query that throws an error that will unlock the db) with our >scheduled site upgrade in about 4 weeks. Try the function <cfset CFUSION_DBCONNECTIONS_FLUSH()> This will do the trick. For a full list of CF functions (including the undocumented ones)follow the link below. http://www.houseoffusion.com/hof/functions.cfm Michael Dinowitz, the host of this list is publishing a book on CF Functions (we are still waiting for it) and this page is a list of all CF Functions and their Params and return values. Regards, Jim Finucane "There was no such thing as the Internet five years ago." --Neil Herman, Smith Barney -------------------------------------------------------------------------------- B L A Z E i n t e r . N E T 103 Pleasant Ave #2 | Jim Finucane - Hoopy Frood Upper Saddle River, NJ 07458 | jim(at)blaze(dot)net 201-825-1313 Fax-825-4949 | http://www.blaze.net -------------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
