> > i use: > > ids = [...generate your list of ids...] > > rows = db(db.board.id.belongs(ids[0:30]).select() > for i in range(30,len(ids), 30): > rows & db(db.board.id.belongs(ids[i:i+30]).select() > > so that gets me my "in" statement working with GAE's 30 items per in limit. >
According to the GAE docs, under the hood that still results in a separate datastore query for every id: http://code.google.com/appengine/docs/python/datastore/gqlreference.html. Anthony