So am I correct in that in order to update the page size I would need to both update the database and also update the variable in the current session? That is, the following is necessary:
db(db.auth_user.id == auth.user.id).update(pagesize=100) auth.user.pagesize = 100 On Tuesday, November 19, 2013 7:28:33 AM UTC-5, Eduardo Cruz wrote: > > db(db.auth_user.id == auth.user.id).update(pagesize=100) > > it will update the database. > > El martes, 19 de noviembre de 2013 03:38:40 UTC-4, User escribió: >> >> I want to store user page size preference for when there is a list view >> of items that needs pagination and have that preference persist between >> logins. Two questions about this: >> >> 1. I decided to add an extra field to my auth.table. Is this the best >> place to store this type of data? >> auth.settings.extra_fields['auth_user'] = [Field('pagesize','integer')] >> >> >> 2. If I want to update that setting how do I do it? >> auth.user.pagesize = 100 >> seems to adjust the pagesize for the current session but does not seem to >> affect the db. >> >> >> -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.