I think inner select belongs are not supported by GAE, but using an array, is. Can anyone confirm what I just said (read the code, didn't test it).
On 21 פברואר, 08:06, "Peter G." <[email protected]> wrote: > 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))).s > elect(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!
