If you are using ColdFusion 5 there is a button in the Administrator (under "Connection Summary") that allows you to "release" all cached data source connections. Very handy. Note however that doing this on a live server (as opposed to a production server) can be problematic. If doing this on a live server it might be prudent to stop services so that you can ensure the data won't be corrupted in the live database. Download it. Compress it. Upload it. Restart services.
BTW: I noticed that American Megatrends (BIOS gods) are using CF! Cheers! Peter Tilbrook ColdGen Pty. Ltd. -----Original Message----- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Friday, 17 May 2002 2:18 PM To: CF-Talk Subject: RE: A Tip (maybe new, maybe not) Then use this one: CFUSION_DISABLE_DBCONNECTIONS (DataSource, switch) I think the switch is a Boolean value.. (?) At 03:56 PM 5/17/2002 +1200, you wrote: >Well, SELECTing a row from a non-existent tables's not likely to create >much havoc. Conversely, CFUSION_DBCONNECTIONS_FLUSH() might not be >polite on a shared host! > >Regards, >Matthew Walker >/* > Easier, smarter forms: > http://www.matthewwalker.net.nz/inform2 >*/ > > > > > > > -----Original Message----- > > From: Jeffry Houser [mailto:[EMAIL PROTECTED]] > > Sent: Friday, 17 May 2002 3:48 p.m. > > To: CF-Talk > > Subject: Re: A Tip (maybe new, maybe not) > > > > > > 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 > > > > > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
