It does indeed....
On Monday, May 9, 2016 at 10:08:56 AM UTC-4, Niphlod wrote:
>
> 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
>> tableVersion
>> 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.
