what are the possible record representation for the IS_IN_DB validator
in this case?
join = (db.auth_membership.group_id==db.auth_group.id)\
&(db.auth_membership.user_id==db.auth_user.id)
requires=IS_IN_DB(db(join), 'auth_group.id')
the string '%(auth_user.first_name)s' is not accepted as I expected and
gave me the subsequent error:
Traceback (most recent call last):
File
"/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/restricted.py", line
205, in restricted
exec ccode in environment
File
"/home/manuele/Dropbox/sviluppo/web2py-1.99.7/applications/dev_plugin_lookout/controllers/plugin_lookout.py",
line 288, in <module>
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/globals.py",
line 173, in <lambda>
self._caller = lambda f: f()
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/tools.py",
line 2575, in f
return action(*a, **b)
File
"/home/manuele/Dropbox/sviluppo/web2py-1.99.7/applications/dev_plugin_lookout/controllers/plugin_lookout.py",
line 275, in share_data_with_users
Field('read_only', 'boolean')
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/sqlhtml.py",
line 1297, in factory
**attributes)
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/sqlhtml.py",
line 870, in __init__
inp = self.widgets.multiple.widget(field, default)
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/sqlhtml.py",
line 283, in widget
return OptionsWidget.widget(field, value, **attributes)
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/sqlhtml.py",
line 216, in widget
options = requires[0].options()
File
"/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/validators.py", line
465, in options
self.build_set()
File
"/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/validators.py", line
447, in build_set
fields = [table[k] for k in self.fields]
File "/home/manuele/Dropbox/sviluppo/web2py-1.99.7/gluon/dal.py",
line 6714, in __getitem__
return dict.__getitem__(self, str(key))
KeyError: 'auth_user.first_name'