It is possible, but I do not recommend.
-Original Message-
From: Spectrum Web [mailto:[EMAIL PROTECTED]
Sent: maandag 2 februari 2004 10:19
To: CF-Talk
Subject: Re:cftransaction HELP Please...
Right?? It's possible to insert another CF scripts inside
cftransaction tags? Do you
Why? Performance loss? Security?
- Original Message -
From: Pascal Peters [EMAIL PROTECTED]
Date: Mon, 2 Feb 2004 14:14:18 +0100
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: cftransaction HELP Please...
It is possible, but I do not recommend.
-Original Message-
From: Spectrum
]
Sent: Monday, February 02, 2004 2:30 PM
To: CF-Talk
Subject: RE: cftransaction HELP Please...
Why? Performance loss? Security?
- Original Message -
From: Pascal Peters [EMAIL PROTECTED]
Date: Mon, 2 Feb 2004 14:14:18 +0100
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: cftransaction HELP
This is possible. However, you have an error with your cftransaction
tags. They ALWAYS require an end tag.
cfif IsOK
cftransaction action=""
cfelse
cftransaction action = ""
/cfif
-Original Message-
From: Spectrum Web [mailto:[EMAIL PROTECTED]
Sent: zondag 1 februari 2004 11:06
I need some help. What Im trying to do is setup a transaction thats
purpose is to move a record from table A to table B and if it is
successful delete it from A. If anything fails roll back and output
the error. Can anyone please offer some insight to either using
different code or
James,
Here is the outline of the code that should work. Just plug in your
queries:
cfset IsOK = True
cftransaction action=begin
cftry
cfquery to read from A
cfcatch
cfset IsOK = False
/cfcatch
/cftry
Andy,
Looks great I'll try this soon! Thank you soo much for your help and time.
Regards,
JB
Andy Ousterhout wrote:
James,
Here is the outline of the code that should work. Just plug in your
queries:
cfset IsOK = True
cftransaction action=begin
cftry
cfquery to read
Dave,
So I dont need the commit and rollback options? I can just use it like
this.. see below
Regards,
JB
CFTRY
cftransaction
CFQUERY NAME=aRecord DATASOURCE=xxx
Select FirstName
FROM tApply
WHERE [identity] = 2
/CFQUERY
CFQUERY NAME=aRecord
Here is the outline of the code that should work. Just
plug in your queries:
... CFTRANSACTION with nested CFTRYs snipped ...
Yikes! You don't need to use exception handling to rollback the transaction
- that's what CFTRANSACTION itself is for! If you have three queries in a
CFTRANSACTION,
So I dont need the commit and rollback options? I can just
use it like this.. see below
That's correct.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~|
Archives:
that a transaction fails?
Andy
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 1:55 PM
To: CF-Talk
Subject: RE: cftransaction HELP Please...
Here is the outline of the code that should work. Just
plug in your queries:
... CFTRANSACTION
To: CF-Talk
Subject: RE: cftransaction HELP Please...
Here is the outline of the code that should work. Just
plug in your queries:
... CFTRANSACTION with nested CFTRYs snipped ...
Yikes! You don't need to use exception handling to rollback
the transaction
- that's what CFTRANSACTION itself
If error rollback, otherwise commit
/cftransaction
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 3:34 PM
To: CF-Talk
Subject: RE: cftransaction HELP Please...
now, if I want to know which of my queries failed and what error message
So with CFTransaction, the only reason to use CFTRY is if you want
additional error handling? For example, if I want details every time this
fails, I could use try within a transaction to capture failure reason? Is
there a better way?
Do you normally attempt to capture the reason that a
now, if I want to know which of my queries failed and what
error message the DB returned for that errant query, I will
need the multiple try/catches within the transaction.
It's been my experience that the CFTRANSACTION itself will return an error
describing the query that went wrong, and
How do you capture the error information?
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 11, 2003 4:19 PM
To: CF-Talk
Subject: RE: cftransaction HELP Please...
now, if I want to know which of my queries failed and what
error message the DB
So with CFTransaction, the only reason to use CFTRY
is if you want additional error handling? For example,
if I want details every time this fails, I could use
try within a transaction to capture failure reason? Is
there a better way?
It's been my experience that you can capture the error
17 matches
Mail list logo