[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