I tried that soluttion but I think it didn´t work as expected, it still
uppdated all records.
I´m using the newest version web2py on linux.
Kenneth
There are several options but the simplest solution is:
form = SQLFORM(db.t_bills, bill['id'], fields=['f_name'])
this way you only affect the listed fields.
On Apr 27, 7:01 pm, Kenneth Lundström<[email protected]>
wrote:
I have a table that I d like to update. Let s say the table has eight
different columns but at the time I d like to only update one of them
via a form.
in controller:
form = SQLFORM(db.t_bills, bill['id'])
if form.accepts(request.vars, session, keepvalues=True):
redirect()
return dict(form=form)
in view:
I have created a custom view with
{{=form.custom.begin}}
{{=form.custom.widget.f_name}}
{{=form.custom.submit}}
{{=bill_items_form.custom.end}}
So I have only one textfield that can be updated. The problem I m facing
is that all rest columns are updated to a NULL value. I tried with
SQLFORM(db.fsdf, fields but no luck.
Kenneth
