You've defined the field as "current_state" (notice the lowercase), but you're trying to update the field "Current_State" (notice the camel case).
You need to replace this: db(db.Exp_Logs_Perm.id == '1').update(Current_State='1') with this db(db.Exp_Logs_Perm.id == '1').update(current_state='1') ... and it should work. El jueves, 26 de julio de 2018, 8:40:45 (UTC-3), [email protected] escribió: > > Hi there, i have created a website that controls a remote lab and i need > every time a user logs in to execute an experiment no other user can log in > to the same experiment station. All i want to do is to update a flag value > in a specific table in the database. In thee controller of the experiment i > added this .. db(db.Exp_Logs_Perm.id == '1').update(Current_State='1')..i > ve tried update record but nothing changed and i am getting this error . > > raise ValueError("No fields to update") > ValueError: No fields to update > > > i define my table inside model db.py. --> > db.define_table('Exp_Logs_Perm',Field('Experiment',requires=IS_NOT_EMPTY()),Field('Info'),Field('current_state',requires=IS_NOT_EMPTY())) > Does the controller executes everytime my html file for this controller is > called?? > > -- 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/d/optout.
