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.

Reply via email to