ok I found the problem, the offset simply needs to be converted to a datetime first. makes sense of course, but it would be great if the article talking about this (http://code.google.com/appengine/articles/paging.html) was updated to reflect that requirement. thanks.
On May 21, 6:13 pm, Frank <[email protected]> wrote: > Hi, > > I have this simple code below to paginate on a list of items that > include a datetime property named 'dCreated' ( dCreated = > db.DateTimeProperty(auto_now_add=True) ) > > offset = self.request.get('offset') > offsetNext = None > > query = Subscription.all().order("-dCreated") > > if offset != "": > query.filter("dCreated <=", offset) > > aItems = query.fetch(limit=21) > > if len(aItems) == 21: > offsetNext = aItems[-1].dCreated > aItems = aItems[:20] > > ...then I put offsetNext and aItems in the template and render it. > the next page is called with offsetNext as offset in the url (...? > offset={{offsetNext}} ) > > the listing works and the items are sorted properly, but it never > change page, the filter on dCreated clearly doesn't have any effect. > > any idea what I'm doing wrong? > > many thanks for the help > Frank --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" 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/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
