Should not this ... video = db(db.Videos.Video_Type == "XXX" and db.Videos.Teacher == "xx").select(db.Videos.ALL)
be rather like this? (see and vs. &) video = db(db.Videos.Video_Type == "XXX" & db.Videos.Teacher == "xx").select(db.Videos.ALL)
Should not this ... video = db(db.Videos.Video_Type == "XXX" and db.Videos.Teacher == "xx").select(db.Videos.ALL)
be rather like this? (see and vs. &) video = db(db.Videos.Video_Type == "XXX" & db.Videos.Teacher == "xx").select(db.Videos.ALL)