I'm trying to obtain a set of rows whose ID values belongs in rows'
fields of another table.
Here's the code:
# Construct a query to fetch all the mootid's from the group
mootGroup =
db(db.moot_groups.gid==groupid)._select(db.moot_groups.mootid)
# Gets moots only if the moot ID exists in the Group query
moots =
db((db.moots.url==request.get_vars.url)&(db.moots.id.belongs(mootGroup))).select(db.moots.ALL)
The error in the admin says this:
File "/base/data/home/apps/356965595645653415/gluon/dal.py", line
3367, in BELONGS
raise SyntaxError, "Not supported"
SyntaxError: Not supported
Thanks!
