I want to insert a form include two fields coursename and teache_id reference auth_user,as students and teachers in the same table(auth_user),so I want to filter content of dropdown in SQLFORM only to show the role is teacher,so i do this query=(db.auth_membership.user_id==db.auth_user.id)(db.courses.teacher_id==db.auth_user.id)(db.auth_membership.group_id==db.auth_group.id)(db.auth_group.role=='teacher') db.courses.teacher_id.requires=IS_IN_DB(db(query),'db.auth_user.id') form=SQLFORM(db.courses) return dict(form=form) but it comes out error:'Query' object is not callable maybe there is error in query so I test it in mysql like this: select auth_user.id from auth_user,auth_membership,auth_group where auth_membership.user_id = auth_user.id and auth_membership.group_id=auth_group.id and auth_group.role='teacher'
it's ok! who can help me! Thanks jian -- 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.
