15 messages in com.mysql.lists.perlRe: LIMIT clause and placeholders
FromSent OnAttachments
Beau E. Cox05 Mar 2004 00:59 
Jochen Wiedmann05 Mar 2004 01:48 
Tim Bunce05 Mar 2004 02:31 
Beau E. Cox05 Mar 2004 03:31 
Rudy Lippan05 Mar 2004 07:19 
Beau E. Cox05 Mar 2004 09:39 
Jochen Wiedmann05 Mar 2004 11:36 
Garth Webb05 Mar 2004 11:47 
Garth Webb05 Mar 2004 11:52 
Jochen Wiedmann05 Mar 2004 12:00 
Daniel Koch05 Mar 2004 12:01 
Jochen Wiedmann05 Mar 2004 12:13 
Rudy Lippan05 Mar 2004 18:03 
Rudy Lippan05 Mar 2004 18:23 
Beau E. Cox05 Mar 2004 18:35 
Subject:Re: LIMIT clause and placeholders
From:Garth Webb (gar@zappos.com)
Date:03/05/2004 11:47:14 AM
List:com.mysql.lists.perl

On Fri, 2004-03-05 at 11:36, Jochen Wiedmann wrote:

Rudy Lippan wrote:

[snip]

For the LIMITS, instead of parsing the statment looking for them I might make DBD::mysql not quote /^(\d+)$/ which would make it work like it did (with LIMITS) before the change, and the ints should get casted to VARCHAR when used as a param to VARCHAR.

Don't. Go to server side placeholders and leave everything to the server as soon as possible.

I was under the impression that MySQL doesn't support placeholders and that the placeholder syntax for DBD::mysql was just for compatibility/continuity with the other DBD::* classes. If you know differently, do you know what version of MySQL supports this?

--

|- Garth Webb -| |- gar@zappos.com -|