On Tue, 4 Dec 2001 14:04:50 -0500, "Benjamin S. Rogers" <[EMAIL PROTECTED]>
wrote:

>The CFTRANSACTION tag is used to bundle multiple queries into a single
>transaction so that the queries can be committed or rolled back as a group.
>This is a fundamental aspect of SQL itself: it is not a short cut.

Dito. The purpose of the sql transaction command as he said is to make
groups of sql statements what is technically called "atomic". This is
absolutely crucial in real-world enterprise environments.

Any database that doesnt support transaction rollbacks I tend to sneer
at as being a toy.

--min
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to