[web2py] Insert record with dynamic multiples fields

[dicolla]

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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.