No its actually by query, if you wrap a cftransaction around a query this
query will not execute until you pass the commit option. Thus you can in
effect queue up a few queries before commiting and be able to roll back if
an error occurs!
regards
Andrew Scott
Senior Cold Fusion Application Developer
ANZ eCommerce Centre
* Ph 9273 0693
* [EMAIL PROTECTED]
-----Original Message-----
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: 24 October 2000 07:05
To: CF-Talk
Subject: CFTRANSACTION
Ok it seems to me the way I am understanding cftransaction is that
it rolls back the transaction only per database? Is that right? If it is
that is kind of worthless since I have a few different databases that are
hinging upon one databases fields being filled in.
Robert Everland III
Web Developer
Dixon Ticonderoga
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]