#33886 [WFx]: PDO Prepared Statement fails if binding id (:blah) is used more then once.

From: Date: Wed, 27 Jul 2005 14:20:42 +0000
Subject: #33886 [WFx]: PDO Prepared Statement fails if binding id (:blah) is used more then once.
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-82533@lists.php.net to get a copy of this message 
 ID:               33886
 User updated by:  wb at pro-net dot co dot uk
 Reported By:      wb at pro-net dot co dot uk
 Status:           Wont fix
 Bug Type:         PDO related
 Operating System: FreeBSD 5.4-RELEASE-p2
 PHP Version:      5.0.4
 New Comment:

Fair enougth.

I will submit a note to the php manual about this.

Keep up the good work :)


Previous Comments:
------------------------------------------------------------------------

[2005-07-27 16:13:08] wez@php.net

It's not portable to rely on that.
You need to create three parameters and bind them separately.

------------------------------------------------------------------------

[2005-07-27 16:04:28] tony2001@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip



------------------------------------------------------------------------

[2005-07-27 16:00:07] wb at pro-net dot co dot uk

Using PDO-0.9 and PDO_PGSQL-0.9

------------------------------------------------------------------------

[2005-07-27 15:57:13] wb at pro-net dot co dot uk

Description:
------------
When using the same binding id in a query the PDOStatement::execute()
method still requires you to specify the same amount of parameters.

Reproduce code:
---------------
<?php
$pdo = new PDO('pgsql:host=localhost dbname=bats user=user
password=pass');
$pdo->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_EXCEPTION);

$statement = $pdo->prepare("
            UPDATE groups
            SET
               lft = CASE WHEN lft > :right
                     THEN lft + 2
                     ELSE lft END,
               rgt = CASE WHEN rgt >= :right
                     THEN rgt + 2
                     ELSE rgt END
            WHERE
              rgt >= :right
            ");
$statement->execute(array(':right' => 5));

?>

Expected result:
----------------
Would expect the statement to execute without issue.

Actual result:
--------------
PHP Fatal error:  Uncaught exception 'PDOException' with message
'SQLSTATE[08P01]: <<Unknown error>>: 7 ERROR:  bind message supplies 1
parameters, but prepared statement "pdo_pgsql_stmt_08257c0c" requires
3' in /usr/home/wb/bats/scripts/tests/pdoQuery.php:17
Stack trace:
#0 /usr/home/wb/bats/scripts/tests/pdoQuery.php(17):
PDOStatement->execute(Array)
#1 {main}
  thrown in /usr/home/wb/bats/scripts/tests/pdoQuery.php on line 17



------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=33886&edit=1

Thread (8 messages)

« previous php.bugs (#82533) next »