Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: toolbar problems (GT::SQL::Display::HTML::Table)

May 30, 2001, 11:03 AM
Alex
Administrator (9387 posts)
May 30, 2001, 11:03 AM
Views: 2509
Shortcut
Quote Reply
Re: toolbar problems (GT::SQL::Display::HTML::Table) In reply to
Hi,

The problem is with:

Code:
my $hits = $sth->rows;
The ->rows() method returns the actual number of rows fetched, not the total number of results the query would have matched. For instance in the search logger, when you get the first page of results, ->rows() only returns 5. Since you pass this into the toolbar, it thinks there are no more results.

What it should say is:

Code:
my $hits = $db->hits;
Hits returns the actual count of rows that would have been returned if we hadn't limited the results.

I'll fix up the SearchLogger! Thanks!

Cheers,

Alex

--
Gossamer Threads Inc.
Subject Author Views Date
Thread toolbar problems (GT::SQL::Display::HTML::Table) shetland 2660 May 29, 2001, 10:37 PM
Thread Re: toolbar problems (GT::SQL::Display::HTML::Table) 		Alex 2509 May 30, 2001, 11:03 AM
Post Re: toolbar problems (GT::SQL::Display::HTML::Table) 		shetland 2502 May 30, 2001, 12:44 PM