Well, he's asking specifically about CFQUERY... And as for an SP, wouldn't the transaction have to be controlled inside the SP itself? I don't see how a CFTRANSACTION in your template could control the internal working of a SP.
Chris > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 09, 2003 9:07 AM > To: CF-Talk > Subject: RE: cftransaction quick question > > > No true (well at least for Stored Procedures) as what if the > SP does 10 > other things before the actual failure? i.e. if you are > simply doing one > update - then no need for a rollback / update etc BUT for an SP you do > require at least a commit or rollback. > > > > > -----Original Message----- > From: Lofback, Chris [mailto:[EMAIL PROTECTED] > Sent: 09 July 2003 14:04 > To: CF-Talk > Subject: RE: cftransaction quick question > > > > My thinking is that if the single query fails, there wouldn't be any > > need for a rollback.... how does that sound? > > Sounds good to me. AFIK, a query either succeeds or > fails--there's no such > thing as partial success in a SQL statement. So if the query > fails, there's > no change in the DB that would need to be rolled back. > > Chris > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4