cftransaction question

[Netopole]

Hi there ! Let's say i have a first query which inserts a new row in a table,
then a second query (myquery) trying to get the id of the inserted row (with a
select max(id) as myid). Obviously, i will put that into a cftransaction tag so
i'm sure to get the proper id. But now, i add a cfset myvar = myquery.myid.
Should the cfset be inside the cftransaction, or outside ? Does it make any
differences ? Thanx for you inputs. Best regards,

[OldCFer]

It can be outside, since myquery.myid are ColdFusion results which were retrieved
inside the cftransaction tag. Once the result set is returned, you no longer care
what DB changes occur.

[Netopole]

Thanx, that's what i thought, but i wanted to make sure.