| AFAIK SQLObject overloads the slicing operators so something like Class.select()[start:end] results in a query like: SELECT .... FROM class LIMIT end-start+1 OFFSET start
However, I haven't tested it and I might be plain wrong :)
Alberto On 23/03/2006, at 3:25, Jorge Vargas wrote:
On 3/21/06, Jorge Godoy <[EMAIL PROTECTED]> wrote:
"gasolin" <[EMAIL PROTECTED]> writes:
> The question is "How to select ten entries as a set and then offset to
> next set"?
> I tried the " Class.select(expr.., limit=10)" but nothing happen at all.
Class.select(expr)[start:end]
I found that ugly. Your getting ALL your data to use only a part of it. It's elegant python code but it's horrible on performance if you want to get the results 10 at a time and you have 100 you will fetch 1000 records....
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/turbogears
-~----------~----~----~----~------~----~------~--~---
|
- [TurboGears] Re: [Question] Search Pagination Alberto Valverde
-
