db(db.table.id.belongs(myset)).select()
Il giorno mercoledì 19 dicembre 2012 10:07:33 UTC+1, Rocco ha scritto:
Dear all,
I need to extract multiple records from a table, the number of selected
records is variable (from 1 to hundreds).
The user form returns a list of selected ids, f.e.:
myset=[1,15,22,44,56]
In the raw sql way, I used a for loop to generate the where clause of the
sql statement, to get f.e.:
SELECT * from table
WHERE (id=1 or id=15 or id=22 or id=44 or id=56)
I expected to find some DAL tool to avoid the db.executesql usage, but I
wasn't able to do it.
I hoped that I could pass the list as argument, in this way:
db(db.table.id==myset).select()
but doens't work...
any suggestions?
--