Execute Stored mssql in phpcake 3.x

Need Help
1

Hello,

I have stored mssql. I use query in sql server manager “Exec sp_POS_0002 ‘SG01’, ‘000000000010022260’, ‘CAI’, ‘2’, ‘O’;” and result 3 row

But i call it in phpcake(note: connect mssql ok not error, i execute select table mssql have result row)

$connect = ConnectionManager::get(“sub”);
$rs = $connect->execute(“Exec sp_POS_0002 ‘SG01’, ‘000000000010022260’, ‘CAI’, ‘2’, ‘O’;”)->fetchAll(‘assoc’);

phpcake result “message”: “SQLSTATE[IMSSP]: The active result for the query contains no fields.”
I dont’ know driver php error or phpcake error or i not enough defined
I use php driver php_pdo_sqlsrv_56_ts.dll and php_sqlsrv_56_ts.dll
Thanks!

2

resolve :D. Error stored “set nocount on”. Thanks all

3

$query = “SELECT * FROM TABLE NAME”;
$conn = new PDO(“sqlsrv:Server=YOURHOST;Database=DBNAME”, “USERNAME”, “PASSWORD”);
$stmt = $conn->prepare($query);
$stmt->execute();
$results = array();
do {
$results [] = $stmt->fetchAll();
} while ($stmt->nextRowset());

echo ‘

’;

print_r($results);

      $stmt->closeCursor();
      unset($stmt);