Re: A transaction in transaction? Possible?

I thought nested transactions are available in the new
release (8) coming up.

Ted

--- Andrei Bintintan <klodoma@ar-sd.net> wrote:

> Is it possible to have another transatction in a
> transaction??? In the following example the last
> ROLLBACK is totally ignored(transaction1). 
> 
> //connect to database
> $database = dbConnect($dbhost, $dbuser, $dbpass,
> $dbname);
> dbExec($database, "BEGIN"); //transaction1
> 
> //*
>         dbExec($database, "BEGIN");//transaction2
>             $sql = "UPDATE orders SET
> technikernotiz='51' WHERE id=16143";
>             dbExec($database, $sql);
>         dbExec($database, "COMMIT");//transaction2
> /**/
> 
>     $sql = "UPDATE orders SET
> reklamationsdetail='51' WHERE id=16143";
>     dbExec($database, $sql);
> dbExec($database, "ROLLBACK");//transaction1
> 
> dbClose($database);
> 
> 
> 

    
__________________________________ 
Do you Yahoo!? 
Check out the new Yahoo! Front Page. 
www.yahoo.com