Re: bind parameter for LIMIT statement

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

Julien GILLES wrote:
> __PACKAGE__->add_constructor(lasts => 'keywords like ? ORDER BY date
> DESC LIMIT %s');
> 
> ==> DBD::mysql::st execute failed: called with 2 bind variables when 1
> are needed
> 
> I misunderstund something...

You have to actually pass a value for the %s when you call it.  See the 
Ima::DBI docs for an example.

- Perrin