Re: Transaction

[Lee Borkman]

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">   </cftransaction> </cfcase> Is that the kind of thing you are looking for, or have I completely misunderstood?  Hope it helps, LeeBB ----- Original Message ----- From: Shahzad.Butt   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 was sent to: archive@jab.org 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 ==^================================================================