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]
