Re: [web2py] String to query

2015-11-20 Thread Anthony
On Friday, November 20, 2015 at 5:54:26 AM UTC-5, Massimiliano wrote: > > If I’m not missing something you can you do: > > table = ‘memos’ > field = ‘construction_site’ > param1 = 1 > param2 = 2 > > query = (db[table][field] == param1) > query = query | (db[table][field] == param2) > Note, you can

Re: [web2py] String to query

2015-11-20 Thread Gael Princivalle
Thanks a lot Massimiliano for both solutions. Il giorno venerdì 20 novembre 2015 12:30:12 UTC+1, Massimiliano ha scritto: > > … but if you really want to use a string you can do: > > query = eval(“db.memos.construction_site == 1") > > On Fri, Nov 20, 2015 at 11:53 AM, Massimiliano > wrote: > >> I

Re: [web2py] String to query

2015-11-20 Thread Massimiliano
… but if you really want to use a string you can do: query = eval(“db.memos.construction_site == 1") On Fri, Nov 20, 2015 at 11:53 AM, Massimiliano wrote: > If I’m not missing something you can you do: > > table = ‘memos’ > field = ‘construction_site’ > param1 = 1 > param2 = 2 > > query = (db[t

Re: [web2py] String to query

2015-11-20 Thread Massimiliano
If I’m not missing something you can you do: table = ‘memos’ field = ‘construction_site’ param1 = 1 param2 = 2 query = (db[table][field] == param1) query = query | (db[table][field] == param2) On Fri, Nov 20, 2015 at 11:32 AM, Gael Princivalle < gaelprinciva...@gmail.com> wrote: > Hello all. >

[web2py] String to query

2015-11-20 Thread Gael Princivalle
Hello all. I need to build a query in a loop. Query is a string like: query = "db.memos.construction_site == 1" So query is a string and when I use it in a grid: grid_memos = SQLFORM.grid(query=query) It fails. 'str' object has no attribute '_db' How can I resolve it? Thanks, regards. -- Re