[web2py] Re: records as fields in a single form

[Annet]

@Massimo,

Thanks for your reply.
I gave the code a try I had to remove name= from the Field definition, now 
I am stuck at form=SQLFORM.factory(*fields_list)
it gives me the following error:

Traceback (most recent call last):
  File "/Users/annet/web2py/gluon/restricted.py", line 212, in restricted
    exec ccode in environment
  File "/Users/annet/web2py/applications/init/controllers/cmssite.py" 
<http://127.0.0.1:8000/admin/edit/init/controllers/cmssite.py>, line 536, in 
<module>
  File "/Users/annet/web2py/gluon/globals.py", line 188, in <lambda>
    self._caller = lambda f: f()
  File "/Users/annet/web2py/gluon/tools.py", line 2912, in f
    return action(*a, **b)
  File "/Users/annet/web2py/applications/init/controllers/cmssite.py" 
<http://127.0.0.1:8000/admin/edit/init/controllers/cmssite.py>, line 97, in 
site_functions
    form=SQLFORM.factory(*fields_list)
  File "/Users/annet/web2py/gluon/sqlhtml.py", line 1534, in factory
    return SQLFORM(DAL(None).define_table(table_name, *fields),
  File "/Users/annet/web2py/gluon/dal.py", line 7086, in define_table
    table = self.lazy_define_table(tablename,*fields,**args)
  File "/Users/annet/web2py/gluon/dal.py", line 7103, in lazy_define_table
    table = table_class(self, tablename, *fields, **args)
  File "/Users/annet/web2py/gluon/dal.py", line 7512, in __init__
    self[field_name] = field
  File "/Users/annet/web2py/gluon/dal.py", line 7680, in __setitem__
    .update(**self._filter_fields(value)) is None:
  File "/Users/annet/web2py/gluon/dal.py", line 7606, in _filter_fields
    return dict([(k, v) for (k, v) in record.iteritems() if k
AttributeError: 'Field' object has no attribute 'iteritems'


I have a similar function in which I use SQLFORM.factory() with a fixed 
Field set:

form=SQLFORM.factory(
    Field('phone',length=128,requires=IS_LENGTH(128)),
    Field('fax',length=128,requires=IS_LENGTH(128)),
    Field('cell_phone',length=128,requires=IS_LENGTH(128)),
    Field('email',length=128,requires=requirement,label=label),
    
Field('URL',length=128,requires=IS_EMPTY_OR(IS_URL(prepend_scheme=None))),
    separator='')

In the function I am working on now I'd like to use SQLFORM.factory() with 
a variable Field set
hence the fields_list solution. Why doesn't this work?


@Alan,
Thanks for your reply, I am using Allan Jardines datatables, however, for 
reasons of consistency I prefer
a form based solution. Furthermore, I no longer import crud, so I am 
looking for a none crud solution.


Kind regards,

Annet

--