ID: 42917
Updated by: [EMAIL PROTECTED]
Reported By: remi dot lanvin at bsocom dot com
-Status: Open
+Status: Assigned
Bug Type: PDO related
Operating System: Linux 2.6.17.8
PHP Version: 5.2.4
-Assigned To:
+Assigned To: iliaa
Previous Comments:
------------------------------------------------------------------------
[2007-10-10 13:34:12] remi dot lanvin at bsocom dot com
Description:
------------
Using PDO::FETCH_KEY_PAIR as an argument to
PDOStatement->setFetchMode() cause an error.
Note : PDO::FETCH_KEY_PAIR works well when used directly as an argument
to fetchAll() without setFetchMode().
Reproduce code:
---------------
$dbh = new PDO($dsn, $login, $password);
$sql = 'SELECT id, login FROM user u';
$results = $dbh->query($sql);
$results->setFetchMode(PDO::FETCH_KEY_PAIR);
print_r($results->fetchAll());
Expected result:
----------------
An associative array ('id' => 'login')
Actual result:
--------------
SQLSTATE[22003]: Numeric value out of range: Invalid fetch mode
specified
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=42917&edit=1
