note 9850 added to mssql_query

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

« previous php.notes (#8178) next »