Hi Sam, On May 25, 2009, at 10:58 AM, Sam Carleton wrote:
> Example: Following the logic of the ScrollingCursor page, lets assume > a total result set of 88 titles. If the lasttitle happens to be the > 29th title, so the set that is returned is 30 through 34, how do I > determine that this is the 6th page of a total of 18 pages? Let's assume 88 titles. For the sake of the argument, say you decide to display 12 per page. That would be 88 / 12 = 7.3 = 8 pages. If you need to know in which page a specific title lies (say 63), you can do something like ceil (63 % 12) = ceil (5.25) = 6th page. Following the same logic, ceil (88 / 12) = 8 pages total. Does that answer your question? Cheers, -- Tito _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
