Re: MSSQL Atomic Operation
| From: | Robert Twitty | Date: | Thu, 22 May 2003 16:42:42 +0000 |
| Subject: | Re: MSSQL Atomic Operation | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27969@lists.php.net to get a copy of this message | ||
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
>
>