Use Distributed transaction control from within SQL. Don't let CF deal with
it. You need a Stored proc which calls each of the three sp's within a
distributed transaction. If either of them fails you need to trap the error
and rollback the transaction. I'd put normal transaction contrpol within
each of the sp's aswell.
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 488 9131
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: MIKE GEORGE [mailto:[EMAIL PROTECTED]]
Sent: 07 May 2001 19:36
To: CF-Talk
Subject: cfstoredproc and cftransaction
What is the best way of handling the following situation.
I have 3 stored procedures I want to call from coldfusion and once all 3
have executed sucessfully, I want to commit them, if any fails, I want to do
a rollback.
Can this be done with cftransaction or is that only to be used with the
cfquery stuff.
Thanks.
Database: ORACLE 8
ColdFusion 4.5
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
