Try, unchecking "maintain database connections" and also try running a
query which generates an ODBC error just before you upload the new
spreadsheet. This will generally unlock your DB. If you wrap it in a
CFTry/Catch statement you could run the bad query and upload the new file
from a single template...
bd
At 10:27 AM 18/12/00 +1000, you wrote:
>Hi,
> I have a problems with Cold Fusion and an Excel spreadsheet. I am
>using the spreadsheet to give me rates for currency calculation, work fine.
>Problem is it needs to be updates , new spreadsheet, loaded every day.
>Problem happens when I try to upload a new spreadsheet, the old one is
>locked by Cold Fusion. Is there a way to unlock this file and then upload
>or upload a different file and change the DNS name so that Cold Fusion looks
>at the new file.
>
>Brian Knott
>QANTM Australia
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
