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

Andy Grundman andy at hybridized.org
Fri Sep 23 03:08:18 BST 2005


Rhesa Rozendaal wrote:
> Andy Grundman wrote:
> 
>> 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:
>>
>>
>> This will be solved by upgrading to the latest DBD::mysql. :)
> 
> 
> I had hoped i would, but I just did upgrade it to 3.0002 before mailing
> the list. As far as I know, I'm using all the latest releases:
> - DBD::mysql v3.0002
> - Class::DBI v0.96
> - Class::DBI::Sweet v0.05
> 
> Don't tell me I'll be needing to run developer releases, please. I'd
> rather just use the 'disable_sql_paging' flag.
> 
> Thanks for the hint, nonetheless :)

Hmm, sorry then.  I could have sworn we had this problem crop up several 
times and it was always fixed by upgrading to the latest DBD::mysql. 
I'm also running 3.0002 and have no problems with limit queries in Sweet.

My versions:
DBD::mysql 3.0002, mysql 4.0.24 (Gentoo Linux)
Class::DBI 0.96
Sweet 0.05
SQL::Abstract 1.20

-Andy




More information about the ClassDBI mailing list