Re: bind parameter for LIMIT statement

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

On Wed, Jan 26, 2005 at 11:22:11AM +0100, Julien GILLES wrote:
> __PACKAGE__->add_constructor(lasts => 'keywords like ? ORDER BY date
> DESC LIMIT %s');
> 
> My::Package->lasts("%foo%", 5);

That's not going to work, by any stretch of anyone's imagination.

add_constructor isn't going to be of much use here. You need to set the
SQL up directly: 

__PACKAGE__->set_sql(lasts => 'keywords like ? ORDER BY date DESC LIMIT %d');

And then call it like:

  my @results = Class->sth_to_objects(Class->sql_lasts(5), "%foo%");

Tony