Skip Menu |

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)

History Show all quoted text
  Tue Jul 19 16:03:55 2005 Guest - Ticket created
Subject: searching with maypole
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.
  Tue Aug 09 05:21:38 2005 cpan.zerofive [...] googlemail.com - Taken
  Tue Aug 09 05:26:13 2005 cpan.zerofive [...] googlemail.com - Correspondence added
[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.
  Sun Aug 12 18:10:37 2012 majestic [...] cpan.org - Ticket deleted
  Sun Aug 12 18:10:46 2012 majestic [...] cpan.org - Status changed from 'deleted' to 'open'