note 9850 deleted from function.mssql-query by didou
| From: | didou@php.net | Date: | Sun, 04 Feb 2007 14:10:25 +0000 |
| Subject: | note 9850 deleted from function.mssql-query by didou | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-122817@lists.php.net to get a copy of this message | ||
Note Submitter: mark at gamezone dot co dot za
----
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