RE: [KCFusion] While were on the subject
We use CFTransaction for all our update, delete and insert queries. However we also use the ctfry cfcatch within the CFTransaction to catch database errors. We have not ventured to used CFTransaction by itself. Betty -Original Message- From: Daryl Banttari [mailto:[EMAIL PROTECTED]] Sent: Monday, December 04, 2000 7:28 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] While were on the subject Depends. Most DBMS'es will not allow you to roll back table manipulation commands. CFTransaction is typically used to ensure that a given set of individual updates leave the database in the state where either (all updates happened) or (none of the updates happened), and is not one of the top 10 most-used tags. Daryl - Original Message - From: "Bryan LaPlante" [EMAIL PROTECTED] To: "[KCFusion List] (E-mail)" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 4:28 PM Subject: [KCFusion] While were on the subject Has anyone used CFTRANSACTION? is that goofy example in the doc's correct? I am trying to create alter and or delete database tables on the fly based on the needs of my current application, I know this sounds wacky but trust me there is a method to the madness. I am wondering if cftransaction will manage those types of queries. Anybody know? Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] ** __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] While were on the subject
I do this same thing, only I am creating dynamic views on the database server when a user logs on and keeping them there until they log off.(VERY fast performance on large DB's) So no CFTRANSACTION is used there... BUT I have used it on one page where I create a table at entry (of the page), then run the query, then delete the temp table. THAT is where CFTRANSACTION is valuable. (You are not trying to delete a table while you are reading data from it!) Doug Teetzen Bushnell Performance Optics 913.752.3466 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bryan LaPlante Sent: Monday, December 04, 2000 4:28 PM To: [KCFusion List] (E-mail) Subject: [KCFusion] While were on the subject Has anyone used CFTRANSACTION? is that goofy example in the doc's correct? I am trying to create alter and or delete database tables on the fly based on the needs of my current application, I know this sounds wacky but trust me there is a method to the madness. I am wondering if cftransaction will manage those types of queries. Anybody know? Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] While were on the subject
Depends. Most DBMS'es will not allow you to roll back table manipulation commands. CFTransaction is typically used to ensure that a given set of individual updates leave the database in the state where either (all updates happened) or (none of the updates happened), and is not one of the top 10 most-used tags. Daryl - Original Message - From: "Bryan LaPlante" [EMAIL PROTECTED] To: "[KCFusion List] (E-mail)" [EMAIL PROTECTED] Sent: Monday, December 04, 2000 4:28 PM Subject: [KCFusion] While were on the subject Has anyone used CFTRANSACTION? is that goofy example in the doc's correct? I am trying to create alter and or delete database tables on the fly based on the needs of my current application, I know this sounds wacky but trust me there is a method to the madness. I am wondering if cftransaction will manage those types of queries. Anybody know? Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]