Bug #69743 [Opn->Fbk]: Prepared statements in IN not returning values
Edit report at https://bugs.php.net/bug.php?id=69743&edit=1
ID: 69743
Updated by: cmb@php.net
Reported by: dmitriy dot y at gmail dot com
Summary: Prepared statements in IN not returning values
-Status: Open
+Status: Feedback
Type: Bug
Package: ODBC related
Operating System: CentOS 7
PHP Version: 5.5.25
-Assigned To:
+Assigned To: cmb
Block user comment: N
Private report: N
New Comment:
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
For a start, it might be helpful to not suppress errors for a test
script.
Previous Comments:
------------------------------------------------------------------------
[2015-06-01 19:48:25] dmitriy dot y at gmail dot com
Description:
------------
This works fine on Windows 8.1 64-bit, but when migrated to CentOS 7, it returns null. Connecting to
MS SQL Server 2012.
Test script:
---------------
Works:
$res = @odbc_exec($db, 'SELECT CustomerID FROM Customers WHERE CustomerID IN
(1000,999,1013)');
Does not work:
$query = odbc_prepare($db, 'SELECT CustomerID FROM Customers WHERE CustomerID IN
(?,?,?)');
$res = @odbc_execute($query, array(1000,999,1013));
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=69743&edit=1
Thread (3 messages)