note 112298 added to pdostatement.fetch
| From: | sumariva at gmail dot com | Date: | Wed, 29 May 2013 18:02:53 +0000 |
| Subject: | note 112298 added to pdostatement.fetch | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-194985@lists.php.net to get a copy of this message | ||
I got problems during fetch of stored procedures with mssql following PDOException:
SQLSTATE[IMSSP]: The active result for the query contains no fields
with a a prepared statement like:
EXEC [mydb].[stored_procedure_that_returns_select] ?;
The solution was to supress the count of records
SET NOCOUNT ON; EXEC [mydb].[stored_procedure_that_returns_select] ?;
Hope it helps!
----
Server IP: 187.73.33.55
Probable Submitter: 143.54.235.155
----
Manual Page -- http://php.net/manual/en/pdostatement.fetch.php
Edit -- https://master.php.net/note/edit/112298
Del: integrated -- https://master.php.net/note/delete/112298/integrated
Del: useless -- https://master.php.net/note/delete/112298/useless
Del: bad code -- https://master.php.net/note/delete/112298/bad+code
Del: spam -- https://master.php.net/note/delete/112298/spam
Del: non-english -- https://master.php.net/note/delete/112298/non-english
Del: in docs -- https://master.php.net/note/delete/112298/in+docs
Del: other reasons-- https://master.php.net/note/delete/112298
Reject -- https://master.php.net/note/reject/112298
Search -- https://master.php.net/manage/user-notes.php