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 > > > > > > > > > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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