try to prefix yourself with the following situation db.define_table('sometable', Field('somefield1'), Field('somefield2'))
and then request.vars as {'somefield1' : 'abcd', 'somefield2' : 'cdef', '*contents*': 'wxyz'} trying to do db.sometable.validate_and_insert(**request.vars) will give you the exact same error ("Field *contents *does not belong to the table") On Monday, May 9, 2016 at 3:11:51 PM UTC+2, Mark Billion wrote: > > Dumb question and even though I have rtmed I cannot seem to find what I am > sure is right in front of me. > > I have a form that sends back data ordered by table name and I want to do > something like > > validate_and_insert(**request.vars) > > That being said, this doesnt work.... > > > > <type 'exceptions.SyntaxError'> Field contents does not belong to the table > Version > web2py™ Version 2.12.3-stable+timestamp.2015.08.19.00.18.03 > Python Python 2.7.6: /usr/local/bin/uwsgi (prefix: /usr)Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > > Traceback (most recent call last): > File "/home/www-data/web2py/gluon/restricted.py", line 227, in restricted > exec ccode in environment > File "/home/www-data/web2py/applications/t4/controllers/default.py" > <https://104.131.18.58/admin/default/edit/t4/controllers/default.py>, line > 3560, in <module> > File "/home/www-data/web2py/gluon/globals.py", line 412, in <lambda> > self._caller = lambda f: f() > File "/home/www-data/web2py/applications/t4/controllers/default.py" > <https://104.131.18.58/admin/default/edit/t4/controllers/default.py>, line > 28, in storage_form_controller > ret = db.storage_lockers.insert(**request.vars) > File "/home/www-data/web2py/gluon/packages/dal/pydal/objects.py", line 712, > in insert > ret = self._db._adapter.insert(self, self._listify(fields)) > File "/home/www-data/web2py/gluon/packages/dal/pydal/objects.py", line 629, > in _listify > 'Field %s does not belong to the table' % name) > SyntaxError: Field contents does not belong to the table > > Error snapshot [image: help] > <https://104.131.18.58/admin/default/ticket/t4/75.150.158.78.2016-05-09.09-05-42.8ad1ae83-9f51-4100-b978-04eda00ba5c5#> > > Locals: > eld : <pydal.objects.Field object> > fields : {'bank_name_address': 'd', 'client': '9', 'contents': '1141', > 'date_surrender_or_trans': '1', 'id': '', 'kind': 'Storage Locker', > 'others_with_access': 'dte'} > name : 'contents' > new_fields : {'bank_name_address': (<pydal.objects.Field object>, 'd'), > 'client': (<pydal.objects.Field object>, '9'), 'date_surrender_or_trans': > (<pydal.objects.Field object>, '1'), 'id': (<pydal.objects.Field object>, > ''), 'kind': (<pydal.objects.Field object>, 'Storage Locker')} > self : <Table storage_lockers > (id,client,kind,others_wi...ntents_5,date_surrender_or_trans,content_string)> > update : False > value : '' > -- 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/d/optout.