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 <[email protected] > <javascript:>> 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] >> <javascript:>> 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] <javascript:>. >>> 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.
