note 26845 added to function.mssql-query
| From: | wind at wag dot nl | 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