Interesting, in CFTRANSACTION you have to reference the same DSN. I wonder
how Phil uses multiple DSN's between CFTRANSACTION Tags?
Neil
----- Original Message -----
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 24, 2000 8:21 AM
Subject: RE: "Newbie" trying to understand CFTRANSACTION
> > I'm reading about this CFTRANSACTION tag, and I'm not really
> > clear on what it's used for.
> >
> > The CF Web App Const. Kit book states that it "...implements
> > transaction and
> > rollback processing. Any <CFQUERY> tags placed between
> > <CFTRANSACTION> and
> > </CFTRANSACTION> tags are automatically rolled back if an error occurs."
> >
> > Am I correct in interpreting this to mean that if, for example in my own
> > application, when a user submits a form to an action page that updates
my
> > database AND also sends off various emails, that if the query pulling
the
> > emails from the email table fails, the other updates to the database
will
> > still be made?
> >
> > If I'm off base here, what are the practical applications of this tag?
>
> OK, it's used in cases where you have to add data to several tables, and
> possibly across several datasources
>
> Say you was adding a new item to a shopping cart, and it had several
entries
> into the product reference table
> If any of the inserts fail, then nothing would be added, so you don't get
> orphan records
>
> Another possible use, is to get the latest identity from a table - it's
not
> 100% effective for this, but works on smaller applications
>
> HTH
>
> Philip Arnold
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **********************************************************************
> 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
> the system manager.
> **********************************************************************
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
