hi,
i have a query in is_in_db requires but not work properly
e.g.
*models/db.py*
employee = db(db.employee.auth_user == 1).select().first()
db.booking.room.requires = IS_IN_DB(db((db.room.status == 'Available') and
(db.room.branch == employee.branch)), db.room.id, db.room._format) if
auth.user else None
*traceback*
Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
Traceback (most recent call last):
File "C:\web2py\gluon\restricted.py", line 227, in restricted
exec ccode in environment
File "C:/web2py/applications/hotel/models/db_wizard_4_booking.py"
<https://127.0.0.1/admin/default/edit/hostel/models/db_wizard_4_booking.py>,
line 3, in <module>
employee = db(db.employee.auth_user == 1).select().first()
File "C:\web2py\gluon\packages\dal\pydal\base.py", line 929, in __getattr__
return ogetattr(self, key)
AttributeError: 'DAL' object has no attribute 'employee'
*test on web2py python shell (work fine)*
print db(db.employee.auth_user == 1).select().first()
print db(db.room.branch == 1).select().first()
employee = db(db.employee.auth_user == 1).select().first()
print employee.branch
is there related to modular dal?
thanks and best regards,
stifan
--
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.
