> > I can think of two ways to do it, but I don't like either one. First > is to formulate the query without the limitby clause and do a > db(query).count(). That would give me the total number of records in > the set. Then add the limitby clause to the query to get the records > of interest.
FYI, I think this is how SQLFORM.grid does it. Anthony
