Just before the CFABORT, try placing the CFTRANSACTION check in again and
close the transaction if there is one open.
-Justin Scott, Lead Developer
Sceiron Internet Services, Inc.
http://www.sceiron.com
- Original Message -
From: Shawn Grover [EMAIL PROTECTED]
To: CF-Talk [EMAIL
Nope, got the same error. Thanks though.
Any other ideas/insight?
Shawn Grover
-Original Message-
From: Justin Scott [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 10:23 AM
To: CF-Talk
Subject: Re: CFTransaction Rollback on error?
Just before the CFABORT, try placing
You are using action=begin on the opening CFTRANSACTION call right?
-Justin Scott, Lead Developer
Sceiron Internet Services, Inc.
http://www.sceiron.com
- Original Message -
From: Shawn Grover [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 16, 2002 1:28 PM
Yep. Something like this:
cftransaction action=Begin
cftry
cfquery name=SomeUpdate...
/cfquery
!--- The Error Handler handles any controled errors ---
cfmodule
template=MyErrorHandler.cfm
I generally use cftry/cfcatch in conjunction with cftransaction.
This allows you to roll back if errors are encountered.
You really don't have to do this. That's one of the features that
CFTRANSACTION provides for you. If you have multiple queries within a single
transaction, and any fails
Ok I don't think the ODBC drivers I have support the cftransaction, how can
I be sure though, there isn't an error message. If I am updating a record
and I rollback at the end, it should go back to the number it was before,
correct? Or does it only work for inserts.
Robert Everland III
Dixon
Ok I don't think the ODBC drivers I have support the
cftransaction, how can I be sure though, there isn't
an error message. If I am updating a record and I
rollback at the end, it should go back to the number
it was before, correct? Or does it only work for
inserts.
Yes, if you make
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 5:51 AM
To: CF-Talk
Subject: RE: CFtransaction crap
I generally use cftry/cfcatch in conjunction with cftransaction.
This allows you to roll back if errors are encountered.
You
I have an AS/400 and I am not sure if it supports transactions and I
want to test it. Is the syntax for cftransaction correct below. I would like
to pretend there is an error right after I insert the newlinenumber and I
would like to roll that back.
cftransaction action=BEGIN
Robert,
I generally use cftry/cfcatch in conjunction with cftransaction. This
allows you to roll back if errors are encountered. The general outline is
this:
cftransaction action=BEGIN
cfset doCommit = True
cfquery whatever...
some sql...
/cfquery
cfquery whatever...
some
Whoops, This should be correct. Sorry for the mis-code. :)
Robert,
I generally use cftry/cfcatch in conjunction with cftransaction. This
allows you to roll back if errors are encountered. The general outline is
this:
cftransaction action=BEGIN
cfset doCommit = True
cftry
cfquery whatever
Just checking: queries that are run from CF Tags that are
called within a CFTRANSACTION block are counted as part
of that transaction, yeah? Seems obvious, but the whole
compartmentalisation of CF Tags gave me little doubts...
- Gyrus
- [EMAIL PROTECTED]
work: http
Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Friday, 15 February 2002 9:23 PM
To: CF-Talk
Subject: CF tag queries within CFTRANSACTION
Just checking: queries that are run from CF Tags that are
called within a CFTRANSACTION block are counted as part
of that transaction, yeah? Seems
It seems that many problems I see in this list revolve around determining
the next record for an insert and methods to use cftransaction as a form of
database locking to achieve this purpose. So, I figured I would add two
cents that might help some of you.
First, what you can do is determined
Laboratory Services
Office: (800) 604-5227
Cell: (407) 491-9848
-Original Message-
From: Rick Walters [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 10:48 AM
To: CF-Talk
Subject: RE: Inserting and CFTransaction
It seems that many problems I see in this list revolve around
Access doesn't have any good way to prevent the multiple
simultaneous insert problem. So, by using CFCatch, and
CFTransaction you can catch the error of the second insert,
rollback the changes and try again with a new value.
CFTransaction seems to suggest that your set of queries
To: CF-Talk
Subject: RE: Inserting and CFTransaction
Access doesn't have any good way to prevent the multiple
simultaneous insert problem. So, by using CFCatch, and
CFTransaction you can catch the error of the second insert,
rollback the changes and try again with a new value.
CFTransaction
and
Update queries. The majority of errors occur when modifying
the data.
There's nothing wrong with that, I don't think. What I should have said, was
that you don't need to use it within the CFTRANSACTION. The CFTRANSACTION
won't run subsequent queries if the first one fails (assuming they're using
Nested instances of cftranasction aren't always caught and cause a core dump on w2k...
happens with included templates that contain a second cftranasction
it will crash your cf 5.0 server
hopefully will help someone tearing there hair out :-)
Hey again,
Dave Watts assured me yesterday that I should be able to use
CFSTOREDPROC and CFQUERY inside a CFTRANSACTION with the same datasource
and have no problems. Thanks Dave ;-)
Now below is my original post and I am wondering if anyone has
encountered a similar situation with a mix
Dave Watts assured me yesterday that I should be able to
use CFSTOREDPROC and CFQUERY inside a CFTRANSACTION with
the same datasource and have no problems. Thanks Dave ;-)
Now below is my original post and I am wondering if anyone
has encountered a similar situation with a mix
dooowwwn
here was the error:
Error Diagnostic Information
More than one data source used in a CFTRANSACTION
The use of multiple data sources (or multiple username/password
attributes for a single data source) within a CFTRANSACTION is not
permitted. You have attempted
Hey All,
I'm converting a whack load of common queries to stored procedures right
now and I have started getting an error whining about trying to open a
datasource that is already open.
The situation is that in some of my cftransaction blocks I have a mix of
included queries and included
I'm converting a whack load of common queries to stored
procedures right now and I have started getting an error
whining about trying to open a datasource that is already
open.
The situation is that in some of my cftransaction blocks
I have a mix of included queries and included
There is an error in the example code that comes with the CFStudio help
file for CFTRANSACTION. I get this error: Context validation error in tag
CFTRY The tag is not correctly positioned relative to other tags in the
template: the last tag nested inside tag CFTRY must be a CFCATCH tag
You need to change how the try works with transaction...
CFTRANSACTION
CFTRY
!--- Queries Here ---
CFTRANSACTION ACTION=COMMIT/
CFCATCH
!--- We have experienced an error
in the template:
the last tag nested inside tag CFTRY must be a CFCATCH tag. Currently it is
a CFTRANSACTION tag.
Code:
CFTRY
--
Initialize commitIt to Yes.
---
CFSET
Chad:
Put the CFTRY inside the CFTRANSACTION block. Also, two CFCATCH blocks
aren't needed in that code. The commitIt flag isn't really needed also
unless you want it for something else outside the block. So, something like
this will work:
CFTRANSACTION ACTION=BEGIN
CFTRY
Thanks for the code Mike. It is working now.. Kinda.
Now im getting an error that my database driver does not support
CFTRANSACTION Im using MySQL.
So i take it i will only be able to use CFTRY and CFCATCH to watch for
errors on the SQL statements?
Anyone have a work around or more
Message-
From: Chad Gray [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 10:54 AM
To: CF-Talk
Subject: MySQL and CFTRANSACTION
Thanks for the code Mike. It is working now.. Kinda.
Now im getting an error that my database driver does not support
CFTRANSACTION Im using MySQL
]]
Sent: Tuesday, September 25, 2001 9:54 AM
To: CF-Talk
Subject: MySQL and CFTRANSACTION
Thanks for the code Mike. It is working now.. Kinda.
Now im getting an error that my database driver does not support
CFTRANSACTION Im using MySQL.
So i take it i will only be able to use CFTRY
It looks as if this is fixed in myODBC 2.50.39. Appears to work on my dev
server, but since I'm using myISAM table types I can't test it all the way
thru. Based on the errmsgs, it looks as if the failure I'm getting is
related to my table type, and not CFTRANSACTION itself. If you're using
There is an error in the example code that comes with the
CFStudio help file for CFTRANSACTION. I get this error:
Context validation error in tag CFTRY The tag is not
correctly positioned relative to other tags in the template:
the last tag nested inside tag CFTRY must be a CFCATCH tag
Hello, is there ever a reason to use cftransaction around a single query? I
currently use it around queries that are dependant on each other, but
another coder is using cftransaction around single queries. Just wondering
if this is correct or just a waste. thanks
Depends on what that query is doing, if it's inserting, or updating, yes, if
it's just doing a select no. That's my understanding on the matter.
-Original Message-
From: John Barleycorn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 12:51 PM
To: CF-Talk
Subject: cftransaction
Using a cftransaction for a single statement is not necessary. If the
update or insert statement fails It fails. There are no dependant
queries that rely on that information being correct. I use cftransaction
for multiple inserts or related updates, etc... (although I typically use
stored
in oracle i use it with procedures. since i've found that it's not proper to
put commits and/or rollbacks inside the procs cftransaction comes in handy.
you can control a commit or a rollback per transaction to the db. it also
allows you to use isolation (locking in the db), but i haven't
No.
Cftransaction forces the DB to operate in single-thread mode. The only
realistic reason to use it is if you are using a GET MAX query to retrieve
the ID of a freshly inserted record. Using it anywhere else would only slow
the DB down. The major reason that enterprise-level DBs are so fast
I'm not an expert on transaction integrity and the like, but wouldn't
CFTRANSACTION have no bearing on the retrieval of a newly inserted record?
The possibility will still exist that a newer record has been inserted
between the time of the new record, and the GET MAX query.
- Original
Hi all,
I am trying to push my group into buying Crystal Reports for our
reporting needs. What i want to do is create a secure site where users can
log in and view their reports. Has anyone done this before? which CR version
do you recommend? Developer? Professional or Standard? What
Can anybody explain the cftransaction tag isolation parameter.
As I dont seem to be able to find any information other than
very basic explanations.
What is happeing is if I place a Read_uncommited level on a
DB Read, when I update the same table I get a 'Cannot Update
a table
Hi Does anyone actually use the isolation level Serializable with
cftransaction? I understand that using it can impede performance, is the
trade of worth it to ensure no dirty reads, nonrepeatable reads and phantom
reads?
What are the chances of these data consistency problems occuring with say
-Talk
Subject: RE: CFTRANSACTION
Are you saying that the example in the documentation with regards to using
the ACTION of /ROLLBACK and /COMMIT does not work? I haven't had a need to
use CFTRANSACTION in 4.5 as of yet.
From Documentation:
Within the transaction block, you can commit a transaction
There's this code in an application...
CFTRANSACTION
CFX_Something...
CFQUERY...
INSERT INTO...
/CFQUERY
CFSCRIPT
StructUpdate(..., ..., ...);
/CFSCRIPT
/CFTRANSACTION
Is there any point in having the CFTRANSACTION? I thought CFTRANSACTION only
affected database
Yes, as written this use of CFTRANSACTION is purpose-free. But if the
developer wants to roll back the transaction if the structupdate fails, I
think CFTRY/CFCATCH and CFTRANSACTION type=rollback could be useful.
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent
Yes, as written this use of CFTRANSACTION is purpose-free.
I'll have to remember that phrase... extrememly diplomatic!
Thanks
--
Aidan Whitehall [EMAIL PROTECTED]
Netshopperuk
Telephone +44 (01744) 648650
~~
Structure your ColdFusion code
Speaking of purpose-free the CFTRANSACTION is not even reliable for
multiple queries.
I had a problem with users on a high-volume site having OrderIDs duplicated
and caused major problems. I fixed it by getting the ID within my order
query with that lovely SET NO COUNT option in SQL 7.
I
I don't think a flaw in CFTRANSACTION would not necessarily be a candidate
for causing this kind of problem. CFTRANSACTION is concerned with defining
a set of (usually) database operations as a transaction for roll back
purposes. Most of the problems we've had with this tag stem from misuse
As I understand it, CFtransaction ONLY does just that...it rolls back all
database operations within it if any of them fails. The only way I'm aware
of to be sure that there is no transaction between one query and another is
to use cflock around themor, if using SQL, to retrieve the new ID
Are you saying that the example in the documentation with regards to using
the ACTION of /ROLLBACK and /COMMIT does not work? I haven't had a need to
use CFTRANSACTION in 4.5 as of yet.
From Documentation:
Within the transaction block, you can commit a transaction by nesting the
cftransaction
No...although I haven't used the action attributes of cftransaction, I would
assume that they work just fine. The point I was making is that
CFtransaction does not lock the databaseand therefore doesn't prevent
other (outside) transactions from occuring in between those contained within
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
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
Oktosoma wrote:
Is there any MySQL odbc driver that support cftransaction for use with
CF on linux version ? The included driver (MERANT ODBC) doesn't support
it.
thanks
~~
Structure your ColdFusion code with Fusebox. Get the official book
are looking, or in the
process of developoing though.
I imagine that when the database software supports transactions, the
ODBC driver will be updated to support it.
Dian Oktosoma wrote:
Is there any MySQL odbc driver that support cftransaction for use with
CF on linux version ? The included driver
Terry,
My experience is that it breaks.
--Bill
-Original Message-
From: Terry Bader [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 24, 2001 6:09 PM
To: CF-Talk
Subject: cftransaction
q: in the book, it says not all odbc drivers support all the lock types
so... lets say the back
q: in the book, it says not all odbc drivers support all the lock types
so... lets say the back-end is moved over to a non-supported db, what will
happen when the application hits the cftransaction? will it break or be
ignored??
Terry Bader
IT/Web Specialist
EDO
I know CFTRANSACTION rolls back any cfquery tags between the cftransaction
and the /cftransaction tags if an error occurs, but what about
cfstoredproc tags?
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http
Hi All,
Can anybody explain the cftransaction tag isolation parameter. As I dont
seem to be able to find any information other than very basic explinations.
What is happeing is if I place a Read_uncommited level on a DB Read, when I
update the same table I get a 'Cannot Update a table
Hi. I've got a client that every now and again finds her sequence of
order IDs skips a number. I do the thing where I put cftransaction
around the order being entered, get the max(order_id) as lastorder,
then use that ID for the line items. If there is an error or a
timeout between the ID
Yup, that is exactly what is happening. Once you insert a new record the
autonumber index gets incremented. If you delete that record as happens in
case of an error with cftransaction. The next time a new record is inserted
it just continues on to the next highest number.
jon
- Original
On 2/17/01, Jon Hall penned:
Yup, that is exactly what is happening. Once you insert a new record the
autonumber index gets incremented. If you delete that record as happens in
case of an error with cftransaction. The next time a new record is inserted
it just continues on to the next highest
Message -
From: Bud [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, February 17, 2001 12:26 PM
Subject: Re: cftransaction and Access autonumber
On 2/17/01, Jon Hall penned:
Yup, that is exactly what is happening. Once you insert a new record the
autonumber index gets
I dont think there is any need, as I think a stored proc runs as a
transaction anyway within sql server...
-Original Message-
From: Sandra Clark [mailto:[EMAIL PROTECTED]]
Sent: 12 January 2001 20:20
To: CF-Talk
Subject: cfstoredproc and cftransaction
Does cftransaction work wrapped
No what your looking for is this:
CFTRANSACTION ACTION="BEGIN"
CFTRY
!--- All your insert queries here ---
CFCATCH TYPE="Database"
CFTRANSACTION ACTION="ROLLBACK"/
/CFCATCH
CFCATCH TYPE="Any"
CFTRANSACTION ACTION="ROLLBACK"/
/CFCATCH
/CFTRY
/CFTR
I have three queries that insert information, I need to be
sure that all three inserts take place, if not they are
discarded. How would I use cftransaction to accomplish this
task?
cftransaction
cfquery name="insert1" datasource="#dsn#"
I have three queries that insert information, I need to be sure
that all three inserts take place, if not they are discarded.
How would I use cftransaction to accomplish this task?
Thanks,
Dave
~~
Structure your ColdFusion code with Fusebox. Get
At 02:08 PM 1/16/01 -0500, you wrote:
I have three queries that insert information, I need to be sure
that all three inserts take place, if not they are discarded.
How would I use cftransaction to accomplish this task?
You simply put cftransaction before the first one and /cftransaction
after
cftransaction
cfquery name="insert1" datasource="#dsn#"
sql statement1
/cfquery
cfquery name="insert2" datasource="#dsn#"
sql statement2
/cfquery
cfquery name="insert3" datasource="#dsn#"
I have always have been under the impression that all I had to do was:
CFTRANSACTION
Query 1
Query 2
Query 3
/CFTRANSACTION
With each query wrapped it's own CFQUERY tag.
However, I have never had the oportunity to test it.
Russel
What about using Commit and Rollbacks within the cftransaction?
Are those used for scenarios other than the one I presented?
Thanks Again,
Dave
-Original Message-
From: Russel Madere [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 3:12 PM
To: CF-Talk
Subject: RE
Can I use cftransaction tag in 4.0 with action as an option.
Vani
~~
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
action should either be "BEGIN" or "COMMIT" or "ROLLBACK"
- -Original Message-
From: Vani Kolli [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 15, 2001 7:43 AM
To: CF-Talk
Subject: cftransaction...
Can
but it gives me an error if i use it in cf4.0
Vani
-Original Message-
From: Kiran Samudrala [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 15, 2001 10:25 AM
To: CF-Talk
Subject: RE: cftransaction...
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
action should either be "
i get an error if i use action with cftransaction.
-Original Message-
From: Kiran Samudrala [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 15, 2001 10:25 AM
To: CF-Talk
Subject: RE: cftransaction...
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
action should either be "
TED]
Sent: Monday, January 15, 2001 4:02 PM
Subject: RE: cftransaction...
but it gives me an error if i use it in cf4.0
Vani
-Original Message-
From: Kiran Samudrala [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 15, 2001 10:25 AM
To: CF-Talk
Subject: RE: cftransaction...
Can I use cftransaction tag in 4.0 with action as an option?
The ACTION attribute is new to CF 4.5.x.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code
Does cftransaction work wrapped around cfstoredproc?
~~
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
al Message-
From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 3:18 PM
To: CF-Talk
Subject: RE: cflock vs. cftransaction
no, CFLOCK is only for restricting access to a server side variable.
DBs
don't benefit from this.
chris olive, cio
cresco technolog
cftransaction is supposed to wrap a group of querries that form a process.
Such as if someone was purchasing a product and three querries are used, one
to check the user/update user information, pull information from a shopping
cart, and submit the purchase data. you would lock each one
:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 12:41 PM
To: CF-Talk
Subject: cflock vs. cftransaction
Hi all. When advancing the ID in a database by pulling up the max(id)
as maxid then cfset newid = query.maxid + 1 and inserting the new
record, I've always used cftransaction around
To: CF-Talk
Subject: cflock vs. cftransaction
Hi all. When advancing the ID in a database by pulling up the max(id)
as maxid then cfset newid = query.maxid + 1 and inserting the new
record, I've always used cftransaction around the queries. This gives
an error in MySQL that transactions aren't
: cflock vs. cftransaction
cftransaction is supposed to wrap a group of querries that form a process.
Such as if someone was purchasing a product and three querries are used, one
to check the user/update user information, pull information from a shopping
cart, and submit the purchase data. you would
Yes, but like he said .. transactions aren't supported my MySQL.
Todd Ashworth
- Original Message -
From: "Greg Wolfinger" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, December 13, 2000 1:29 PM
Subject: Re: cflock vs. cftransaction
| cftra
CFLOCK doesn't provide the same effect as cftransaction. In MySQL you can
lock your tables, though. It's a little cumbersome. It basically means
that MySQl is only handling one request at a time... Here's some code that
Tage Widsell posted to this listserv earlier this month:
cfquery
no, CFLOCK is only for restricting access to a server side
variable. DBs
don't benefit from this.
No, CFLOCK restricts access to a chunk of code. The CFLOCK you suggested
should work, but won't you need to wrap READONLY CFLOCKs around every other
query for the database?
On 12/13/00, Evan Lavidor penned:
CFLOCK doesn't provide the same effect as cftransaction. In MySQL you can
lock your tables, though. It's a little cumbersome. It basically means
that MySQl is only handling one request at a time... Here's some code that
Tage Widsell posted to this listserv
I understand that CF doesn't have the notion of constants,
but I thought that by setting cfset application.constInt = 5
and by never changing it during the execution of the application
in fact (for all practical purposes) we declared a constant.
It seams that the general agreement among
| Yes. But actually cftransaction is used if you have more than one SQL
| statement (insert or update) that have to be either all committed or all
| rollback.(It's all or nothing deal)
Well, I have several select/inserts that span several tables that all need
to be run at once. All or nothing
Is a cftransaction block single threaded, or do I have to provide my own
database side locking for it? The docs aren't very clear on this at all.
Todd Ashworth
~~
Structure your ColdFusion code with Fusebox. Get the official book
Yes. But actually cftransaction is used if you have more than one SQL
statement (insert or update) that have to be either all committed or all
rollback.(It's all or nothing deal)
For a single update or insert statement the table is looked for the time of
the transaction by the dbEngine so you
I have a programmer working for me doing some data conversion using CF
4.5.1 sp1. The database is Oracle 8.1.6 on NT using native drivers. He
wrapped the code in CFTRANSACTION and it is database intensive code. A lot
of selects/updates. When he runs the code, it locks out all other database
That's the whole point of using CFTRANSACTION; it gives you the ability to
roll back multiple transactions if something goes wrong. This is
accomplished by doing a database lock.
Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center
-Original
Ok it seems to me the way I am understanding cftransaction is that
it rolls back the transaction only per database? Is that right? If it is
that is kind of worthless since I have a few different databases that are
hinging upon one databases fields being filled in.
Robert Everland III
Web
Ok it seems to me the way I am understanding
cftransaction is that it rolls back the transaction
only per database? Is that right? If it is that is
kind of worthless since I have a few different
databases that are hinging upon one databases fields
being filled in.
You're correct
No its actually by query, if you wrap a cftransaction around a query this
query will not execute until you pass the commit option. Thus you can in
effect queue up a few queries before commiting and be able to roll back if
an error occurs!
regards
Andrew Scott
Senior Cold Fusion Application
Is there a way to know (programatically - not looking at the db) if the
queries in a cftransaction were successful? Does cftransaction return a
failed code???
If not - does cftry/catch offer a way of knowing if the inserts were
completed???
THX
I need to be able to tell if the transaction block rolled back or
committed...is there a way to do this??? Programatically NOT by looking in
the db.
JP
_
Get Your Private, Free E-mail from MSN Hotmail at
Typically if a CFTRANSACTION block rolls back, an exception is generated as well,
aborting the entire page, unless of course you are using CFTRYCFCATCH statements
to grab and handle the transaction. If you are, you could tell exactly what went
wrong and attempt to correct (of course proper
i have a complex transaction that i have grouped into
multiple includes. i am trying to wrap them into a transaction
so that if any part fails, i can rollback.
cftransaction action="begin"
cfinclude template="part1.cfm" (if exception, rollback)
cfinclude
401 - 500 of 538 matches
Mail list logo