It's a known problem. cfunctions are not transaction aware, meaning the any query inside a cffunction will be automatically committed\rollback .
I really hope that this issue will be fix in the next updater. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm ----- Original Message ----- From: "Ulf Unger" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, December 08, 2002 6:20 PM Subject: CFC's and transactions > Hi, > > I have a problem using <CFTRANSACTION> and CFC's with my DBMS (MySQL): > > If I start a transaction and in this transaction I invoke a method which > returns my next primary key ID (cause it is stored in another table, > and I update the primary key table with an incremented value) and I have > to do a rollback - the table which stores my primary key Ids is not > rolled back. If I include all these queries in one method (not in > different) theres no problem. > > Is this a known issue or is this a specific MySQL problem? > > I use MySQL with InnoDB table handler which enables SQL ANSI > transactions. > > Can somebody help me? > > Thanks in advance > > Ulf > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm