Hi,
I have query to get subset of stuff (and I want to have the same nice
options widget as is for default foreign keys)
sf.requires = IS_IN_DB( db(query), db.table.other_id ,
label=other_table._format, left=left, distinct=True )
but I get
form = SQLFORM.factory( *updatables, table_name="jurgio")
File "/home/jurgis/dev/web2py_src/gluon/sqlhtml.py", line 1809, in factory
**attributes)
File "/home/jurgis/dev/web2py_src/gluon/sqlhtml.py", line 1286, in __init__
inp = field.widget(field, default)
File "/home/jurgis/dev/web2py_src/gluon/sqlhtml.py", line 388, in widget
options = requires[0].options()
File "/home/jurgis/dev/web2py_src/gluon/validators.py", line 598, in options
self.build_set()
File "/home/jurgis/dev/web2py_src/gluon/validators.py", line 573, in build_set
fields = [table[k] for k in self.fieldnames]
File "/home/jurgis/dev/web2py_src/gluon/packages/dal/pydal/objects.py", line
510, in __getitem__
raise KeyError(key)
KeyError: 'role'
I could do select myself and construct IS_IN_SET -- but how can I fluently
get all the fields needed for foreign _format (if _format varies
depending on other_table)?
any suggestions?
Thanks
--
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.
