Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
Jim-sama #1
CFtransaction error
I'm getting the following error:
Nested transactions are not supported.
A cftransaction tag can not be nested within another cftransaction tag.
What i'm trying to do:
I have an array of data that either all has to be ok, or the whole thing is
rejected.
<cftransaction action="begin">
<cftry>
<cfloop loop over an array>
Do Work
If bad element, CFTHROW
</cfloop>
<cfcatch>
cftransaction action="rollback" />
</cfcatch>
</cftry>
<cftransaction action="commit" />
</cftransaction>
Jim-sama Guest
-
cftransaction
I have a question about CFTRANSACTION. We are currently using CF6.0 with various versions of Oracle and SQL Server. In our server settings we do... -
CFTransaction doesn't rollback on error
Hi all, years ago on CF 4.5, our cftransaction tags used to rollback changed data when something inbetween <cftransaction> and </cftransaction>... -
CFTransaction rollbacks
When I am in a transaction and an an error forces me to issue a rollback, my database effectively locks up. I have the feeling that isolation level... -
Error with cftransaction
I have a method with a cftransaction and inside the cftransaction calls a method that has a cftransaction, before updating to 6.1 I didnt have any... -
is this possible - cftransaction
I don't want to get into the whole 'users shouldn't have access to the db' discussion. It's a battle that's been lost. We are looking at... -
-
Jim-sama #3
Re: CFtransaction error
I found my problem. On certain occasions, a certain cf module was being called
that also had a transaction in it.
I'm bypassing this by using cfhttp to call a page that calls that module.
only now, i'm running into a lock situation as both transactions are locking
the same table.
Jim-sama Guest



Reply With Quote

