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] Dynamic ORDER BY
Actually, the tick quotes there should be unnecessary. What does the query look like in the debug output? Daryl - Original Message - From: "Ryan Hartwich" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 04, 2000 3:54 PM Subject: RE: [KCFusion] Dynamic ORDER BY Keith, Check to make sure if you are passing column names via variable, the column names have a tick mark around them: Order By '#VarName#', Column2 Likewise, check that your cfif statement uses a tickmark if necessary around the variable values. Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Purtell Sent: Monday, December 04, 2000 3:37 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Dynamic ORDER BY I have an odd SQL problem in CFQUERY. I'm trying to make an ORDER BY section dynamic. I don't get error messages, but the second ORDER BY parameter is ignored. Here's a chart of the results. Is there a workaround? (We're on CF4.0, NT4, SP5.) ORDER BY Column1, Column2- this works very well ORDER BY #VarName#, Column2 - ignores Column2 - CFIF statement here - ORDER BY Column1, Column2- ignores Column2 - /CFIF - Keith Purtell, Web Designer VantageMed Corporation __ 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] __ 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]