Hi,
I would like to seek knowledge/expertise.
I have this function - which shows "all user activity in the previous 90
days"
def all_activity():
tabledata=TR(B('Date/Time'),B('User'),B('Activity'),_style='background-color:lightblue;')
#formatted header
for row in
db(db.activity.date_time>datetime.datetime.today()-datetime.timedelta(days=91)).select(db.activity.date_time,
db.activity.user_email,db.activity.activity,
orderby=~db.activity.date_time):
tabledata=CAT(tabledata,TR(TD(row.date_time.strftime('%d %b %Y,
(%H:%M %p)'),_style='white-space:nowrap;'),row.user_email,row.activity))
#using CAT() to build the rows
return dict(rows=TABLE(tabledata))
Although it may seem an unusual way to create a table (is it?), it
works..... except that when I get to about 350 records I get this error:
RuntimeError: maximum recursion depth exceeded in cmp
After some elimination-testing, it seems the CAT() helper is at the root of
the issue
If the function is written like this:
def all_activity():
tabledata=[]
tabledata.append(TR(B('Date/Time'),B('User'),B('Activity'),_style='background-color:lightblue;'))
for row in
db(db.activity.date_time>datetime.datetime.today()-datetime.timedelta(days=91)).select(db.activity.date_time,
db.activity.user_email,db.activity.activity,
orderby=~db.activity.date_time):
tabledata.append(TR(TD(row.date_time.strftime('%d %b %Y, (%H:%M
%p)'),_style='white-space:nowrap;'),row.user_email,row.activity))
#essentialy using a tuple instead of CAT()
return dict(rows=TABLE(tabledata))
...the error appears to go away.
Yes - I know that the second verion of the function (using tuples) is a
better way - it was just that I was taken by surprise with the error.
My function is not recursive, but raising a recursive exception.
So, I want to get the view of experts why the CAT() helper would be causing
the problem?
Essentially, is re-iterating CAT() causing a recursive issue?
If so, is there a way to make the CAT() helper work in this scenario?
BTW - this is on 2.9.5+rocket+sqlite. I also have the issue with
2.9.5+apaches+mod_wsgi
I saw a note one this forums that claims a move to MySQL would solve the
error. But I am note sure I have exactly the same symptoms and scenario.
Thanks for the guidance.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
