[Catalyst] Class::DBI::Sweet LIMIT clause with placeholders
qef at ungwe.org
Wed Jun 8 12:46:35 CEST 2005
On Tue, Jun 07, 2005 at 05:29:48PM -0400, Perrin Harkins wrote:
> FYI, Tim Bunce seems to think that the LIMIT clause with placeholders
> that Class::DBI::Sweet uses will no longer work with recent DBD::mysql
> releases. Is anyone else experiencing this?
I've seen problems with things like "LIMIT ?" after upgrading to
Debian Sarge (a couple of months ago, before the release).
I don't know if it was a MySQL problem or DBD::Mysql. The versions
now are 4.0.24 and 2.9006 respectively. Perhaps something has changed
in DBD::Mysql to make it put quotes round numbers when they are
quoted, like strings? If you have "LIMIT '1'" then that's a syntax
error in both MySQL 4.0 and 3.23.
--- Geoff Richards -------------><-------------- http://ungwe.org/ ---
"I tried to fling my shadow at the moon,
The while my blood leapt with a wordless song." -- Theodore Roethke
More information about the Catalyst