Say I have code that is accesses multiple datasources. CFTransaction cannot be
used across multiple datasources.
My question is can I make two CFTransaction blocks and on the first one set a
CFTransaction SavePoint.
Then if the second CFTransation errors can I roll back the first CFTransaction
save point?
Dummmy code:
Cftransaction start
Cftransaction set a save point1
Do some queries on datasource 1
Cftransaction end
Cftransaction start
Cftry
Cftransaction set save point2
Do some queries on datasource 2
Cfcatch
Cftransaction rollback save point 1
Cftransaction rollback save point 2
Cftransaction end
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353039
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
