Hi Adam The mssql ext does not natively support Atomic operations, i.e. transactions. I have never tried this with the mssql ext, but you might be able to do something like this: mssql_query( "BEGIN TRAN tran_Name" ); mssql_query( ... ); mssql_query( "COMMIT TRAN tran_Name" ); -- bob On 22 May 2003, Adam Voigt wrote: > Anyone know how to do atomic operations > with the mssql_query function, so that > if any of the query's fail in the line, > it will not keep the changes made by any > of them? > > > -- > Adam Voigt (adam@cryptocomm.com) > Linux/Unix Network Administrator > The Cryptocomm Group > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
