… 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 <[email protected]> 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) > > > On Fri, Nov 20, 2015 at 11:32 AM, Gael Princivalle < > [email protected]> wrote: > >> 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. >> >> -- >> 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 [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Massimiliano > -- Massimiliano -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
