ID: 36053
Comment by: phpbugs at filofox dot com
Reported By: tzlee at tzlee dot com
Status: No Feedback
Bug Type: PDO related
Operating System: Linux
PHP Version: 5.1.2
Assigned To: wez
New Comment:
I can verify this bug, using MySQL 4.1.11 on PHP 5.1.2.
Previous Comments:
------------------------------------------------------------------------
[2006-01-30 01:00:04] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2006-01-22 19:30:35] [EMAIL PROTECTED]
What version of MySQL are you using?
------------------------------------------------------------------------
[2006-01-17 16:22:03] [EMAIL PROTECTED]
Assigned to the maintainer.
------------------------------------------------------------------------
[2006-01-17 16:19:00] tzlee at tzlee dot com
Description:
------------
Using a param (e.g. :id) more than once in a prepared statement used to
work with my older PHP 5.0.4 (PDO 1.0.2 and PDO_MySQL 1.0.1) but now
breaks with PHP 5.1.2 (using default PDO and PDO_MySQL ext included in
download)
Reproduce code:
---------------
$stmt = $db->prepare("SELECT id, name FROM table WHERE id = :id OR
parent = :id");
$stmt->assignValue(':id', 1, PDO::PARAM_INT);
$stmt->execute();
Expected result:
----------------
Should work
Actual result:
--------------
Failed with General Error
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=36053&edit=1
