Correct. Kind of cool, isn't it. :)
Actually, it's all done on the SQL side. CFTRANSACTION is just a way of
wrapping it all up with ColdFusion logic and processing.
If you want to know more about what is actually going on, or you would
prefer a pure SQL solution, have a look at the BEGIN|COMMIT TRANS[ACTION]
statements.
However, I'd recommend just using the <CFTRANSACTION> statement because it
works very well and is extremely easy to implement.
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
-----Original Message-----
From: Scott Becker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 26, 2000 11:44 AM
To: CF-Talk
Subject: CF Transactions
If you wrap a CF transaction around two <CFQUERY>'s, one being an INSERT and
the NEXT being an UPDATE, if there is an error in the UPDATE, will it
actually
roll back the INSERT?
Thanks,
Scott
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free Setup
from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support Visit
SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists