note 91301 added to pdostatement.execute

From: Date: Thu, 04 Jun 2009 14:15:48 +0000
Subject: note 91301 added to pdostatement.execute
Groups: php.notes 
Request: Send a blank email to php-notes+get-156362@lists.php.net to get a copy of this message
Weird diference between php versions when using the same parameter twice in a request $sql = 'SELECT * FROM ( (SELECT COUNT(id) AS nbPosts FROM post WHERE sujet_id IN (SELECT id FROM sujet WHERE forum_id = :id)) AS t1 , (SELECT COUNT(id) AS nbPostsRecents FROM post WHERE sujet_id IN (SELECT id FROM sujet WHERE forum_id = :id) AND DATEDIFF(now(),publication) <= 0) AS t2)'; $rs = parent::preparedSelect($sql,); $stm = $this->cnx->prepare($sql); $rs = $stm->execute(array(':id'=>1)); Under php 5.2.1 Gentoo : Warning: PDOStatement::execute() [function.PDOStatement-execute]: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in ... Under php 5.2.9-1 Windows : Works fine ---- Server IP: 89.31.146.176 Probable Submitter: 90.12.147.153 ---- Manual Page -- http://www.php.net/manual/en/pdostatement.execute.php Edit -- https://master.php.net/note/edit/91301 Del: integrated -- https://master.php.net/note/delete/91301/integrated Del: useless -- https://master.php.net/note/delete/91301/useless Del: bad code -- https://master.php.net/note/delete/91301/bad+code Del: spam -- https://master.php.net/note/delete/91301/spam Del: non-english -- https://master.php.net/note/delete/91301/non-english Del: in docs -- https://master.php.net/note/delete/91301/in+docs Del: other reasons-- https://master.php.net/note/delete/91301 Reject -- https://master.php.net/note/reject/91301 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#156362) next »