Edit report at http://bugs.php.net/bug.php?id=40740&edit=1
ID: 40740
Comment by: elim dot css at gmail dot com
Reported by: phpbugs at filofox dot com
Summary: PDO::execute() errors when parameters are used in
LIMIT clause
Status: No Feedback
Type: Bug
Package: PDO related
Operating System: Linux Debian Sarge 3.1
PHP Version: 5.2.1
Assigned To: wez
Block user comment: N
Private report: N
New Comment:
I had this error when I was passing in a value from a form which was a
string. I
had to force the parameter to be an int using (int)$value and do this:
bindValue(":limit", $value, PDO::PARAM_INT);
Previous Comments:
------------------------------------------------------------------------
[2009-09-23 21:13:01] [email protected]
Can we close it as a duplicate and if favour of
http://bugs.php.net/bug.php?id=44639 ?
------------------------------------------------------------------------
[2009-09-08 13:00:43] weblab dot solutions at gmail dot com
And I really surprised this issue not fixed for more than 2 year.
------------------------------------------------------------------------
[2009-09-08 12:56:51] weblab dot solutions at gmail dot com
Try PHP 5.2.9 & 5.3.0 - get the same exception.
------------------------------------------------------------------------
[2009-08-26 16:36:34] seb117 at free dot fr
I don't understand why this bug does not solved ? It's very important,
and we don't use PDO properly with this bug.
------------------------------------------------------------------------
[2009-08-22 05:59:07] marcel dot esser at gmail dot com
Same problem on 5.2.6, Ubuntu Jaunty.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/bug.php?id=40740
--
Edit this bug report at http://bugs.php.net/bug.php?id=40740&edit=1
