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 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
