Re[2]: [PHP-DB] mssql_query & ROLLBACK
| From: | já) | Date: | Tue, 25 Mar 2003 18:00:18 +0000 |
| Subject: | Re[2]: [PHP-DB] mssql_query & ROLLBACK | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26622@lists.php.net to get a copy of this message | ||
> You can't split a transaction between multiple calls to mssql_query. The
> memory used (in the server and client) are cleared between each call.
> You would have to create a batch of statements and execute these with one
> call to mssql_query.
No, I found solution in the end!:
SET XACT_ABORT OFF
It should be by default OFF and it is when I connect using Query
Analyser, but when I connect using PHP, it is ON.
I had to use
mssql_query("SET XACT_ABORT OFF");
and everything works as I expected.
--
\|||/
Prevít (. .) (já) <mailto:prvt@centrum.cz>
--==-o00o-(_)-o00o-==-----------------------------------------------------