replace
form = SQLFORM.grid(db.rig, user_signature=False)
with
form = SQLFORM.grid(db.rig.user_id = auth.user.id,
user_signature=False)
On Saturday, 18 January 2014 10:42:38 UTC-6, David wrote:
>
> Hey guys,
>
> It's been a while since I used web2py and I've pretty much forgotten
> everything. Try as I might for the last two days I can't quite figure this
> out.
>
> I used a web2pyslice to create a main application which manages
> authentication. I have another app referencing main to
> login/logout/register etc. It works great.
>
> I'm having troubles understanding SQLFORM queries. The problem I'm having
> is using SQLFORM to select records only for a specific auth.user_id. I
> can't seem to figure out how it wants to be handled. I get all kinds of
> error messages while trying to perform this so I will just post my code
> that works and hopefully can advise on how I would select records
> pertaining to the user that created them.
>
>
>
> db.define_table(
> 'rig',
> Field('user_id', default=auth.user_id, readable=False,
> writable=False),
> Field('name'),
> Field('ipaddress'),
> Field('port'),
> format = '%s(name)s')
>
> @auth.requires_login()
> def edit_rigs():
> form = SQLFORM.grid(db.rig, user_signature=False)
> return dict(form=form)
>
> This returns all entries for all users. I only want the current logged in
> user to see his/her own records.
>
> Thank you for any help.
>
>
--
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/groups/opt_out.
