I'd like to convert this static INSERT command:
db_handle.MYTAB.insert(date='1212121', time='999999' )
in a dynamic command like this:
wFields=[]
wFields.append( {'date':'1212121'} )
wFields.append( {'time':'999999'} )
db_handle.MYTAB.insert(wFields)
but I got an error:
Error processing ..., insert() takes exactly 1 argument (2 given)
If I use:
db_handle.MYTAB.insert(*wFields)
I got the error:
Error processing ..., insert() takes exactly 1 argument (3 given)
So, how can I build dynamically the set of parameters when calling the
function INSERT of WEB2PY ?
I use this way to create a TABLE with dynamic FIELDS and this works with no
problem:
wFields = []
for key, pos, in template_fields:
wName = str(key)
wFields.append(Field( wName ))
db_handle.define_table('IISLOG', *wFields )
--
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.
