Hello-
I am new to Web2Py and I think I have a simple question, but I've banged my
head on the desk for two hours and searched this forum to no avail.
I have setup a basic database and want to give the user the ability to edit
a series of fields using SQLFORM.grid. I also want users to be logged in
before they can edit the fields (I'd actually prefer they can only edit
fields they inserted, but I will come back to that later...).
Here is my model:
db.define_table('portfolio_data',
Field('portfolio_id'),
Field('close_date', 'date'),
Field('index_value'),
Field('portfolio_value'),
Field('cash_change'))
portfolio_id is simply a sequential number (1, 2, 3) generated when the
user creates the new portfolio.
I created a controller called edit, which takes an argument equal to the
portfolio_id (so edit/1 edits rows for portfolio 1, edit/2 rows for
portfolio 2, etc.)
@auth.requires_login()
def edit():
# get portfolio ID from URL string
passed_id = request.args(0)
query = (db.portfolio_data.portfolio_id == passed_id)
form = SQLFORM.grid(query=query)
return dict(form=form)
When I try to access /default/edit/1, I get a "Not Authorized" error. If I
set user_signature=False in the SQLFORM.grid call, then I'm able to view
and edit the table rows without a problem.
My diagnosis is that I have something set incorrectly in the authentication
tables. I added a group users and gave them permission to read, update and
select from the table db.portfolio_data, but still no luck. I'm also
confused why I would need to do that at all, since all I'm asking for in
the controller is a login and nothing more (i.e., I'm not restricting table
access anywhere). (And lest anyone ask, I am definitely logged in.)
Are there default table edit restrictions somewhere that I missed in the
documentation? Or is there something else I need to do to get SQLFORM and
auth to play together nicely? I'm working from the default web2py scaffold,
so I'm surprised no one else has run into this issue. The only similar
issue I found was
this<https://groups.google.com/forum/?fromgroups=#!topic/web2py/t3a6KkK41zo>- I
can't even reproduce the issue Kevin highlights in his question.
--
---
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.
