note 112298 added to pdostatement.fetch

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

« previous php.notes (#194985) next »