I think you want:
tablename, fieldname = specificTableToSearchMembersFromID.split('.')
db.Role.object_super_object_FK.requires = IS_IN_DB(db
(db[tablename][fieldname]),
'cost_center.super_object_fk', '%(cost_center_title)s', zero = T('choose
one'))
On Friday, 1 September 2017 16:36:10 UTC-5, Alex Glaros wrote:
>
> this works
>
> db.Role.object_super_object_FK.requires = IS_IN_DB(db (
> db.cost_center.id), 'cost_center.super_object_fk',
> '%(cost_center_title)s', zero = T('choose one'))
>
> but when I try to pass the table name as a var, it doesn't understand the
> var
>
> specificTableToSearchMembersFromID = 'cost_center.id'
> db.Role.object_super_object_FK.requires = IS_IN_DB(db ([
> specificTableToSearchMembersFromID]), 'cost_center.super_object_fk',
> '%(cost_center_title)s', zero = T('choose one'))
>
> <type 'exceptions.AttributeError'> 'DAL' object has no attribute '
> db.cost_center.id'
>
> thanks
>
> Alex Glaros
>
--
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.
