You cannot paginate on GAE (efficiently), offset/count is O(n) and google will not let you offset beyond 2000, so you must add a unique sequential field and use next=unique_seq_value to reference the start of the next page.
See: http://sites.google.com/site/io/building-scalable-web-applications-with-google-app-engine Robin On Feb 10, 2:30 am, ANDROSoft <sebastian.woldan...@gmail.com> wrote: > This error exist only in itemize and when items in table must be > paginated. When i set nitems>count(items in table) everything is > working. Search form is working ok. > > On Feb 9, 1:28 pm, Robin B <robi...@gmail.com> wrote: > > > It appears like it is trying to call str(query) where the query does > > not have a left operator. > > > what happens if you change this: gql.py:591: > > def __str__(self): > > return str(self.left) > > > to this: gql.py:591: > > def __str__(self): > > return str(getattr(self,'left','')) > > > Robin > > > On Feb 9, 4:11 am, ANDROSoft <sebastian.woldan...@gmail.com> wrote: > > > > hello > > > > On GAE i get 'SQLQuery' object has no attribute 'left' after adding a > > > few rows to table > > > > Traceback (most recent call last): > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/ > > > applications/welcome/modules/t2.py", line 39, in t3_execute > > > p=xmlescape(environment['_res']) > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 95, in xmlescape > > > data = str(data) > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 329, in __str__ > > > return self.xml() > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 321, in xml > > > (fa, co) = self._xml() > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 317, in _xml > > > self.components]) > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 95, in xmlescape > > > data = str(data) > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 329, in __str__ > > > return self.xml() > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 321, in xml > > > (fa, co) = self._xml() > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 317, in _xml > > > self.components]) > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 95, in xmlescape > > > data = str(data) > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 329, in __str__ > > > return self.xml() > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 740, in xml > > > return DIV.xml(self) > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 321, in xml > > > (fa, co) = self._xml() > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 315, in _xml > > > fa += ' %s="%s"' % (name, xmlescape(value, True)) > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > html.py", line 95, in xmlescape > > > data = str(data) > > > File "/base/data/home/apps/aspekt-erp/1.331262110087268070/gluon/ > > > contrib/gql.py", line 591, in __str__ > > > return str(self.left) > > > AttributeError: 'SQLQuery' object has no attribute 'left' > > > > code > > > > =self.itemize(db.mebel) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
