Skip Menu |
 
rt.cpan.org will be shut down on March 1st, 2021.

This queue is for tickets about the Class-DBI-Plugin-Pager CPAN distribution.

Report information
The Basics
Id: 13781
Status: open
Priority: 0/
Queue: Class-DBI-Plugin-Pager

People
Owner: cpan.zerofive [...] googlemail.com
Requestors: rmcclain [...] megapath.net
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 0.56
Fixed in: (no value)



Subject: searching with maypole
Download (untitled) / with headers
text/plain 1.3k
If I attempt to use Class::DBI::Plugin::Pager as the pager in my Maypole Application, I get the following when I try to search: caught model error: Can't locate object method "search_where_from_form" via package "Class::DBI::Plugin::Pager" at /usr/local/lib/perl5/site_perl/5.8.6/Maypole/FormBuilder/Model.pm line 344, <GEN4> line 3. Can't locate object method "search_where_from_form" via package "Class::DBI::Plugin::Pager" at /usr/local/lib/perl5/site_perl/5.8.6/Maypole/FormBuilder/Model.pm line 344, <GEN4> line 3. In the dev version, I get the other open bug: caught model error: '1' is not a column of MegaPath::Model::Host at /usr/local/lib/perl5/site_perl/5.8.6/Class/DBI/Plugin/Pager.pm line 299 '1' is not a column of MegaPath::Model::Host at /usr/local/lib/perl5/site_perl/5.8.6/Class/DBI/Plugin/Pager.pm line 299 : at /usr/local/lib/perl5/site_perl/5.8.6/Maypole.pm line 118 You mentioned in private email that you want to do some benchmarking to see if this class is even worth it. I can assure you that it is. For large tables it's absolutely necessary. I'm querying a remote mssql database, and using limits takes a page load on a table of about 45000 rows from 40seconds down to about 5. (I had to kludge 0.56 to work with the mssql Top style limit syntax). It works great for just listing, but searching fails. This is perl 5.8.6 running on linux.
Download (untitled) / with headers
text/plain 1.9k
[guest - Tue Jul 19 16:03:55 2005]: Show quoted text
> If I attempt to use Class::DBI::Plugin::Pager as the pager in my > Maypole Application, I get the following when I try to search: > > caught model error: Can't locate object method > "search_where_from_form" via package "Class::DBI::Plugin::Pager" at > /usr/local/lib/perl5/site_perl/5.8.6/Maypole/FormBuilder/Model.pm > line 344, <GEN4> line 3. > Can't locate object method "search_where_from_form" via package > "Class::DBI::Plugin::Pager" at > /usr/local/lib/perl5/site_perl/5.8.6/Maypole/FormBuilder/Model.pm > line 344, <GEN4> line 3. > > > In the dev version, I get the other open bug: > caught model error: '1' is not a column of MegaPath::Model::Host at > /usr/local/lib/perl5/site_perl/5.8.6/Class/DBI/Plugin/Pager.pm line > 299 > '1' is not a column of MegaPath::Model::Host at > /usr/local/lib/perl5/site_perl/5.8.6/Class/DBI/Plugin/Pager.pm line > 299 > : at /usr/local/lib/perl5/site_perl/5.8.6/Maypole.pm line 118 > > > You mentioned in private email that you want to do some benchmarking > to see if this class is even worth it. I can assure you that it > is. For large tables it's absolutely necessary. I'm querying a > remote mssql database, and using limits takes a page load on a > table of about 45000 rows from 40seconds down to about 5. (I had > to kludge 0.56 to work with the mssql Top style limit syntax). It > works great for just listing, but searching fails. > > This is perl 5.8.6 running on linux.
Ron, thanks for your investigations of this issue [in a separate email]. I hate to say it, but I just can't devote any time to investigating this at the moment. I need to get CDBI::FormBuilder operational for a client. It'll probably be 2 or 3 weeks before I can look at this. If you come up with anything, let me know. If you spot the problem, maybe I can fix it quickly, but it's hunting down the problem that I can't commit to just yet. d.


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.