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? --
