DataMapper ORM v1.8.2

[eluser]tdktank59[/eluser]
[quote author="WanWizard" date="1359649214"]Afaik you can not nest transactions.[/quote]

Apparently you can!
However the way DM uses it, it justs does a normal transaction rather than starting multiple ones.

http://ellislab.com/codeigniter/user-gui...tions.html

Basically by default each transaction is its own, however if you turn on strict mode until they are all committed they are all relying on each other.

So the way I solved it was opened the transaction on the first query and then did some sanity checks and if they failed then I would rollback to the start and get rid of everything I did. Otherwise I would commit the transaction from the first query which would in turn allow everything else.

From CI's docs on transactions, basically what I did by using my first object to open it and then close it at the end after I was satisfied with the same first object.

$this->db->trans_start();
$this->db->query('AN SQL QUERY...');
$this->db->query('ANOTHER QUERY...');
$this->db->query('AND YET ANOTHER QUERY...');
$this->db->trans_complete();

Or something like that... I got it working which is all that matters at this moment.... :p