This is considered bad practice, although it does work. Running an intentionally bad query is not good practice, you never know how it will affect your data
There is a ColdFusion function (undocumented, I believe) called cfusion_dbconnections_flush which will perform the same function. At 11:32 AM 5/16/2002 -0500, you wrote: >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 > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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