note 9850 deleted from function.mssql-query by didou

From: 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

« previous php.notes (#122817) next »