Agreed ... it is funny when I typed in that message earlier today, I laughed and made a comment that it would probably start some kind of 'you can't do that' argument ..:)
I guess with anything it is a good practice to code responsibly .. otherwise you may end up in a ditch or in jail... Cheers Paul Giesenhagen QuillDesign > 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 > > > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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