[Dbix-class] CDBI::Sweet page method
Bernard FRIT
bernard.frit at gmail.com
Wed Aug 3 16:30:49 CEST 2005
Being a bit off topic but looking for some help with CDBI::Sweet...
New to CDBI::Sweet and just playing around :
my $criteria = { auteur => {
-between => [ 'f' , 'z']
}
};
my @livres = Librairie::Livre->search( $criteria ) ;
gives me perfect output as
my @livres = Librairie::Livre->page( $criteria , { rows => 12, page => 3}) ;
gives the following error
DBD::mysql::st bind_param failed: Binding non-numeric field 2, value
undef as a numeric! [for Statement "SELECT me.id, me.id, me.code,
me.libelle, me.auteur, me.prix, me.image
FROM Livre me
WHERE ( me.auteur BETWEEN ? AND ? ) LIMIT ?, ?
"] at /usr/local/lib/perl5/site_perl/5.8.6/Class/DBI.pm line 658.
What am I doing wrong ?
Thanks
--
Bernard FRIT
More information about the Dbix-class
mailing list