note 9850 added to mssql_query
| From: | mark at gamezone dot co dot za | Date: | Tue, 28 Nov 2000 03:58:46 +0000 |
| Subject: | note 9850 added to mssql_query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-8178@lists.php.net to get a copy of this message | ||
With freetds 4.2 (on freebsd) connecting to an MS-SQL7 db, I encountered the problem where certain
INSERT and UPDATE queries were not returning resulting in the script timing out.
It seems as though a query which doesn't return column data, just doesn't return.
To remedy this I append "; SELECT @@IDENTITY" or "; SELECT 1" or any arbitrary
query to my normal insert/update queries, this causes it to return arbitrary column data after the
normal query and thus give control back to php.
-Mark
http://www.php.net/manual/function.mssql-query.php