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