The CFTRANSACTION tag takes care of the top-level rollback all on it's
own. The explicit rollback is only used if you have logic inside the
CFTRANSACTION tag that needs to roll back because of some
non-exception situation. So you'll get the behaviour you want if you
remove the CFTRY..CFCATCH
: Tuesday, July 28, 2009 1:00 PM
To: cf-talk cf-talk@houseoffusion.com
Subject: Re: CFTRANSACTION with MS Access Database
The CFTRANSACTION tag takes care of the top-level rollback all on it's
own. The explicit rollback is only used if you have logic inside the
CFTRANSACTION tag that needs to roll
looks like /cfcatch is missing
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
/cftransaction
--
From: Barney Boisvert bboisv...@gmail.com
Sent: Tuesday, July 28, 2009 1:00 PM
To: cf-talk cf-talk@houseoffusion.com
Subject: Re: CFTRANSACTION with MS Access Database
The CFTRANSACTION tag takes care of the top-level rollback all on it's
Guys cumbersome
below is my code and still its not rolling back ... I have
injected an error in the 2nd insert statement but the transaction
doesn't rolls back... 1st insert takes place... 2nd one has error wat
could be the problem ... dear experts???
Try putting your CFTRY / CFCATCH around the outside of the CFTRANSACTION
... the error handler is not triggering your roll-back, I would guess.
cftry
!---//Starting Transaction
-
cftransaction
!---//QUERY1 Insert
@houseoffusion.com
Subject: Re: CFTRANSACTION with MS Access Database
Try putting your CFTRY / CFCATCH around the outside of the CFTRANSACTION
... the error handler is not triggering your roll-back, I would guess.
cftry
!---//Starting Transaction
try / catch is still the right way to capture errors, but if it's inside
the transaction, then the TR won't fire.
if this isn't working, though, then I gotta question whether Access
supports transaction locking at all? It's been years since I used it, so I
can't vouch one way or the other
No guys this isn't working ... nor that what Barney and Dave advised...
does anyone has a working example of such scenario? I would be very thankful
if someone provides me with a somewhat similar working example
and yes... I am using using CFTRY/CFCATCH because I need to log the
: Re: CFTRANSACTION with MS Access Database
No guys this isn't working ... nor that what Barney and Dave
advised...
does anyone has a working example of such scenario? I would be very
thankful
if someone provides me with a somewhat similar working example
and yes... I am using
arsalk...@hotmail.com
Sent: Wednesday, July 29, 2009 1:00 AM
To: cf-talk cf-talk@houseoffusion.com
Subject: Re: CFTRANSACTION with MS Access Database
hey Dave... can you provide me with some literature or example code on
this
topic ... specially in regard to MS Access
11 matches
Mail list logo