[CDBI] CDBI::Sweet->page() not quite working with mysql?

Andy Grundman andy at hybridized.org
Fri Sep 23 02:33:08 BST 2005


Rhesa Rozendaal wrote:
> Someone please tell me I'm not completely stupid here...
> 
> I'm trying paging with mysql:
> 
>   ($p, $i) = CD->page({}, { rows=>5, page=>1 });
> 
> and it dies on me with an error looking like:
> 
>   DBD::mysql::st bind_param failed: Binding non-numeric field 1, value
>   undef as a numeric! [for Statement "SELECT me.id, me.title
>   FROM   cd me
>   WHERE  1=1  LIMIT ?, ?
>   "] at /usr/lib/perl5/site_perl/5.8.5/Class/DBI.pm line 658.

This will be solved by upgrading to the latest DBD::mysql. :)

-Andy




More information about the ClassDBI mailing list