RE: A Tip (maybe new, maybe not)
Not having to re-establish the connections repeatedly helps with performance. -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 11:02 PM To: CF-Talk Subject: RE: A Tip (maybe new, maybe not) What's the advantage of locking the server on to the database at all? Is it performance? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Subject: Re: A Tip (maybe new, maybe not) Go into the CF Admin and uncheck maintain database connections and your database wont lock at all unless it's actively being accessed by CF. jon Paul Giesenhagen 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. __ 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
Re: A Tip (maybe new, maybe not)
Using SQL Server maintaining the connection would be advantageous because their wouldn't be the overhead for making a new connection, logging in, etc. In Access I don't think it matters. It is only Access after all. If I get concerned about performance of a site based on Access, I upgrade the site to SQL Server if CF's query caching wont do the trick. I believe it's actually reccomended that connections to Access databases are not maintained for memory reasons. jon Mike Kear wrote: What's the advantage of locking the server on to the database at all? Is it performance? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Subject: Re: A Tip (maybe new, maybe not) Go into the CF Admin and uncheck maintain database connections and your database wont lock at all unless it's actively being accessed by CF. jon Paul Giesenhagen 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. __ 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
RE: A Tip (maybe new, maybe not)
you are correct, MM/Allaire best practices for Access DBs says not to use connection pooling. see http://www.macromedia.com/v1/Handlers/index.cfm?ID=1540Method=Full /rob -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 2:26 AM To: CF-Talk Subject: Re: A Tip (maybe new, maybe not) Using SQL Server maintaining the connection would be advantageous because their wouldn't be the overhead for making a new connection, logging in, etc. In Access I don't think it matters. It is only Access after all. If I get concerned about performance of a site based on Access, I upgrade the site to SQL Server if CF's query caching wont do the trick. I believe it's actually reccomended that connections to Access databases are not maintained for memory reasons. jon Mike Kear wrote: What's the advantage of locking the server on to the database at all? Is it performance? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Subject: Re: A Tip (maybe new, maybe not) Go into the CF Admin and uncheck maintain database connections and your database wont lock at all unless it's actively being accessed by CF. jon Paul Giesenhagen 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. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: A Tip (maybe new, maybe not)
There is an undocumented CF Function that will do the same thing. CFUSION_DBCONNECTIONS_FLUSH() I used to use the bogus query to do this as well until I found out about this function. Cheers! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:32 AM To: CF-Talk Subject: A Tip (maybe new, maybe not) 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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
Re: A Tip (maybe new, maybe not)
Even slicker thanks! Paul Giesenhagen QuillDesign There is an undocumented CF Function that will do the same thing. CFUSION_DBCONNECTIONS_FLUSH() I used to use the bogus query to do this as well until I found out about this function. Cheers! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:32 AM To: CF-Talk Subject: A Tip (maybe new, maybe not) 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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: A Tip (maybe new, maybe not)
Might be dangerous Question Is there any way to disconnect from a database programmatically? Answer This is possible, but not recommended, especially if it is a multi-user database. To do so, however, clear the cached connection information with the following code: cfset temp = cfusion_dbconnections_flush() This code flushes all connection information from the cache, but it does not disconnect any actively running requests. -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 1:25 PM To: CF-Talk Subject: Re: A Tip (maybe new, maybe not) Even slicker thanks! Paul Giesenhagen QuillDesign There is an undocumented CF Function that will do the same thing. CFUSION_DBCONNECTIONS_FLUSH() I used to use the bogus query to do this as well until I found out about this function. Cheers! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:32 AM To: CF-Talk Subject: A Tip (maybe new, maybe not) 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
RE: A Tip (maybe new, maybe not)
You can always upload to a second DB, then switch your app to the new DB. This will enable you to unwind if necessary and will diminish you site down-time. Andy -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:42 PM To: CF-Talk Subject: RE: A Tip (maybe new, maybe not) Might be dangerous Question Is there any way to disconnect from a database programmatically? Answer This is possible, but not recommended, especially if it is a multi-user database. To do so, however, clear the cached connection information with the following code: cfset temp = cfusion_dbconnections_flush() This code flushes all connection information from the cache, but it does not disconnect any actively running requests. -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 1:25 PM To: CF-Talk Subject: Re: A Tip (maybe new, maybe not) Even slicker thanks! Paul Giesenhagen QuillDesign There is an undocumented CF Function that will do the same thing. CFUSION_DBCONNECTIONS_FLUSH() I used to use the bogus query to do this as well until I found out about this function. Cheers! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:32 AM To: CF-Talk Subject: A Tip (maybe new, maybe not) 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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: A Tip (maybe new, maybe not)
What usually I do is upload the database to a new name and change the ODBC connection to point to the new file. -- Sam -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:25 AM To: CF-Talk Subject: Re: A Tip (maybe new, maybe not) Even slicker thanks! Paul Giesenhagen QuillDesign There is an undocumented CF Function that will do the same thing. CFUSION_DBCONNECTIONS_FLUSH() I used to use the bogus query to do this as well until I found out about this function. Cheers! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:32 AM To: CF-Talk Subject: A Tip (maybe new, maybe not) 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
Re: A Tip (maybe new, maybe not)
Or you could just run the undocumented function to release it: CFUSION_DBCONNECTIONS_flush() :-) Sharon DiOrio - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 12:32 PM Subject: A Tip (maybe new, maybe not) 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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: A Tip (maybe new, maybe not)
Doesn't that flush every datasource on a server, thus a BIG no-no in a shared hosting environment?? Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 12:25 PM To: CF-Talk Subject: Re: A Tip (maybe new, maybe not) Even slicker thanks! Paul Giesenhagen QuillDesign There is an undocumented CF Function that will do the same thing. CFUSION_DBCONNECTIONS_FLUSH() I used to use the bogus query to do this as well until I found out about this function. Cheers! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email [EMAIL PROTECTED] Hello Stupid, and welcome to your crappy computer. - Strong Bad, HomestarRunner.com -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:32 AM To: CF-Talk Subject: A Tip (maybe new, maybe not) 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
Re: A Tip (maybe new, maybe not)
I should read the rest of the responses first but. But another trick is to set your datasource to one MDB which links to the MDB database which will be uploaded on occasion. Eric From: Paul Giesenhagen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: A Tip (maybe new, maybe not) Date: Thu, 16 May 2002 11:32:09 -0500 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
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 __ 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
Re: A Tip (maybe new, maybe not)
Are you serious? select whatever from notable How will that affect the data? Paul Giesenhagen QuillDesign 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
RE: A Tip (maybe new, maybe not)
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 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
Re: A Tip (maybe new, maybe not)
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
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 __ 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
RE: A Tip (maybe new, maybe not)
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
Re: A Tip (maybe new, maybe not)
Go into the CF Admin and uncheck maintain database connections and your database wont lock at all unless it's actively being accessed by CF. jon Paul Giesenhagen 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! __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: A Tip (maybe new, maybe not)
What's the advantage of locking the server on to the database at all? Is it performance? Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Subject: Re: A Tip (maybe new, maybe not) Go into the CF Admin and uncheck maintain database connections and your database wont lock at all unless it's actively being accessed by CF. jon Paul Giesenhagen 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. __ 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
