note 26845 added to function.mssql-query

From: Date: Thu, 14 Nov 2002 18:55:40 +0000
Subject: note 26845 added to function.mssql-query
Groups: php.notes 
Request: Send a blank email to php-notes+get-39498@lists.php.net to get a copy of this message
Had a similar problem to Jesse What I experienced with Microsoft SQLserver 2000 and PHP 4.1.2 was that if you execute a query consisting of multiple queries separated by a semicolon with mssql_query is that the queries themselves are executed but the connection is dropped immediately after that. It seems that the phpdriver doesn't count on this. The EXEC solution (or maybe sp_executesql) works fine in these cases because to the db-library it is one statement. -- http://www.php.net/manual/en/function.mssql-query.php http://master.php.net/manage/user-notes.php?action=edit+26845 http://master.php.net/manage/user-notes.php?action=delete+26845 http://master.php.net/manage/user-notes.php?action=reject+26845

« previous php.notes (#39498) next »