Try something like this: rows = db(db.cikmis_soru.id.belongs(ids)).select()
On Monday, 15 June 2015 07:13:02 UTC+12, xmarx wrote: > > Hi. > > I want to select a list of id from database. > > ids=[12,145,69] > > how can i do this? Is there any quick way of it? > > for example: > > query="" > for i in ids: > if not i==ids[-1]: > query+="(db.cikmis_soru.id=="+i+")&" > else: > query+="(db.cikmis_soru.id=="+i+")" > > rows=db(query).select() > > > > i get an error: SyntaxError: Set: no tables selected > > Thanks all. > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.