Title: Message
|
Thanks, that was something I was looking
for.
-----Original
Message-----
From: Lee Borkman [mailto:[EMAIL PROTECTED]]
Sent: 29 May 2002 12:37
To: [EMAIL PROTECTED]
Subject: Re: Transaction
Hi Shahzad,
What is the controlling code that is executing the two
query fuseactions? Are you using <cfmodule> calls from something
like a "controller" circuit?
Anyway, assuming that you have an identifiable section
of code that is caling both queries, you can just wrap the two calls in a
<cftranaction> block as usual, eg:
<cfcase value="TwoQueries">
<cftransaction>
<cfmodule
template="#fusebox.rootpath##self#" fuseaction="circuitA.updateA">
<cfmodule
template="#fusebox.rootpath##self#"
fuseaction="circuitB.insertB">
Is that the kind of thing you are looking for, or have I
completely misunderstood? Hope it helps,
LeeBB
----- Original Message -----
Hi,
If I run one query Q1(say update) in
tb_Parent and it is successfully
executed. Now another object(in another
circuit) is trying to run
another query Q2(say insert) in tb_Child, but
on failure of this second
query - insert one, I want to ROLLBACK the transaction which has already
happened in Q1 along with Q2. How can I
make it one transaction as both
queries are being called seperately from
different pages sitting in
different circuits, but somehow they are mutually dependent?
********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the use of the individual or
entity to whom they are addressed. If you have
received this email in error please notify [EMAIL PROTECTED]
or call +44 (0) 1992 701 704. Please note that any views
or opinions presented in this email are solely those of
the author and do not necessarily represent those of
JJ Fast Food Distribution Limited. Finally, the recipient
should check this email and any attachments for the
presence of viruses. The company accepts no liability
for any damage caused by any virus transmitted by
this email.
********************************************************************
==^================================================================
This email was sent to: [email protected]
EASY UNSUBSCRIBE click here: http://topica.com/u/?bUrFMa.bV0Kx9
Or send an email to: [EMAIL PROTECTED]
T O P I C A -- Register now to manage your mail!
http://www.topica.com/partner/tag02/register
==^================================================================
|
