CFTRANSACTION w/ ROLLBACK

[akosz]

Here's what I'm trying to do, this worked in CF 5, but bombs with the following
error in CFMX 6: The <CFCATCH> tag requires an end tag to nest within
<CFTRANSACTION>, which began on line 14, column 2. The first query should
work, the 2nd should bomb, I want the first rolled back.

<CFTRANSACTION ACTION="BEGIN">

<CFTRY>

<CFQUERY name="INSERT_USAGE" datasource="TEST_DB">
INSERT INTO USAGE_TYPE(USAGE_CDE, USAGE_DESC)
VALUES ('999','ABC123')
</CFQUERY>

<CFQUERY NAME="GARBAGE" DATASOURCE="TEST_DB">
INSERT INTO GARBAGE(GARBAGE_CDE)
VALUES('G123')
</CFQUERY>

<CFCATCH TYPE="Database">
<CFTRANSACTION ACTION="ROLLBACK"></CFTRANSACTION>
AN ERROR HAS OCCURRED
</CFCATCH>

</CFTRY>

</CFTRANSACTION>

[paross1]

You might try losing the </cftransaction> in your rollback section, and
rearrange your <cftry> and </cftry> tags.

<CFTRY>
<CFTRANSACTION ACTION="BEGIN" />

<CFQUERY name="INSERT_USAGE" datasource="TEST_DB">
INSERT INTO USAGE_TYPE(USAGE_CDE, USAGE_DESC)
VALUES ('999','ABC123')
</CFQUERY>

<CFQUERY NAME="GARBAGE" DATASOURCE="TEST_DB">
INSERT INTO GARBAGE(GARBAGE_CDE)
VALUES('G123')
</CFQUERY>

<CFCATCH TYPE="Database">
<CFTRANSACTION ACTION="ROLLBACK" />
AN ERROR HAS OCCURRED
</CFCATCH>

</CFTRANSACTION>

</CFTRY>

[mpwoodward *TMM*]

paross1 wrote:

> You might try losing the </cftransaction> in your rollback section, and
> rearrange your <cftry> and </cftry> tags.

Not sure if this is mandatory or not, but that's typically how I do
things--put the try around the transaction instead of vice-versa. Works
in 6.1 and 7.

Matt

--
Matt Woodward
Team Macromedia - ColdFusion

[akosz]

paross1 - I tried your solution but got the following error: The start tag
must have a matching end tag. This could be because CFCATCH is not the last tag
nested in the CFTRY. CFCATCH must be the last tag inside a CFTRY. i don't get
it, this used to work. anybody have a better idea? are there cf admin
settings that need to be adjusted or something?

[akosz]

paross1 - I tried your solution but got the following error: The start tag
must have a matching end tag. This could be because CFCATCH is not the last tag
nested in the CFTRY. CFCATCH must be the last tag inside a CFTRY. i don't get
it, this used to work. anybody have a better idea? are there cf admin
settings that need to be adjusted or something?

[akosz]

found the problem, i had to get rid of the slash at the end of this line:

<CFTRANSACTION ACTION='BEGIN' />

otherwise paross1's answer is correct!

[paross1]

Ooops, sorry, got a little carried away with the closing slash character. Yes,
you would not want to include it with the BEGIN cftransaction, only for "self
closing" purposes on subsequent COMMIT or ROLLBACK cftransaction tags.

Phil