I don�t think its Fusebox related as he cross posted earlier��.. Oh, and if that�s his name, Mork n Mindy have a lot to answer for.......
p.s. HTML emails..... uurgh Neil Clark Team Macromedia http://www.macromedia.com/go/team Announcing Macromedia MX!! http://www.macromedia.com/software/trial/ -----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"> � </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: [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 ==^================================================================
