Hi. You could try: solution = db(db.solution.id.belongs((request.args[0], request.args[1], request.args[2], request.args[3], etc...))).select()
belongs translates to IN in sql. It accepts a list of parameters to which the field will be compared. regards mmlado On Monday 28 September 2009 11:37:29 encompass wrote: > I have this... > solution = db(db.solution.id == request.args[0]).select() > solution_solves = db((db.solution.id == db.solution_solves.solution) & > (db.issue.id == db.solution_solves.issue)) > solved_issues = solution_solves(db.solution.id == solution > [0].id).select() > > and I want to make it so that I can make it look for a list of object > and one long query... > something like this but not so static. > > solution = db(db.solution.id == (request.args[0] | request.args[1] | > request.args[2] | request.args[3] | etc...)).select() > > I hope that makes sence, what do you think is it possible? > Regards, > Jason Brower > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
