Bug #40740 [NoF->Dup]: PDO::execute() errors when parameters are used in LIMIT clause

From: Date: Sun, 26 Jan 2014 18:16:28 +0000
Subject: Bug #40740 [NoF->Dup]: PDO::execute() errors when parameters are used in LIMIT clause
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-184016@lists.php.net to get a copy of this message
Edit report at https://bugs.php.net/bug.php?id=40740&edit=1

 ID:                 40740
 Updated by:         mightyuhu@php.net
 Reported by:        phpbugs at filofox dot com
 Summary:            PDO::execute() errors when parameters are used in
                     LIMIT clause
-Status:             No Feedback
+Status:             Duplicate
 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:

Duplicate #44639


Previous Comments:
------------------------------------------------------------------------
[2010-12-11 07:52:46] elim dot css at gmail dot com

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);

------------------------------------------------------------------------
[2009-09-23 21:13:01] uw@php.net

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.

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


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

    https://bugs.php.net/bug.php?id=40740


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


Thread (18 messages)

« previous php.bugs (#184016) next »