note 37002 added to function.mssql-execute
| From: | iqq-pp at extreme dot ro | Date: | Thu, 30 Oct 2003 08:01:25 +0000 |
| Subject: | note 37002 added to function.mssql-execute | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-59519@lists.php.net to get a copy of this message | ||
php version 4.3.2
Take care when using stored procedures returning multiple results, seems that if the first result is
empty, the pointer will be automatically moved to the next result. As in this example:
CREATE PROCEDURE test
AS
SELECT 0 as zero WHERE 0 = 1
SELECT 1 as one
GO
After executing the stored procedure, mssql_num_rows will report one, ignoring the first result.
----
Manual Page -- http://www.php.net/manual/en/function.mssql-execute.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+37002
Delete -- http://master.php.net/manage/user-notes.php?action=delete+37002&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+37002&report=yes
Search -- http://master.php.net/manage/user-notes.php