Re: bind parameter for LIMIT statement

[prev] [thread] [next] [Date index for 2005/01/25]

On mar, 2005-01-25 at 15:33 +0000, Tony Bowden wrote:
> On Tue, Jan 25, 2005 at 04:20:46PM +0100, Julien GILLES wrote:
> > __PACKAGE__->add_constructor(lasts =3D> 'keywords LIKE ? ORDER BY =
date
> > DESC LIMIT ?');
>=20
> You want to use %s interpolation rather than a placeholder there.

__PACKAGE__->add_constructor(lasts =3D> 'keywords like ? ORDER BY date
DESC LIMIT %s');

=3D=3D> DBD::mysql::st execute failed: called with 2 bind variables when =
1
are needed

I misunderstund something...

--=20
Julien GILLES.



This email communication is confidential and is intended solely for whom =
it is addressed. Copying, or re-using in any way by anyone else is =
unauthorised. Any views or opinions expressed are those of the author =
and do not necessarily represent those of GL TRADE or any of its =
affiliates.=20

If you have received this mail in error, please destroy the copy in your =
possession and notify abuse@xxxxxxx.xxx