Hello!!! Try using Parenthesis, for example:
(db.tventa.id >= 3) & (db.tventa.id <= 7) Result Set tventa.id <http://127.0.0.1:8000/Cascada/appadmin/select/db?orderby=tventa.id> tventa.fecha <http://127.0.0.1:8000/Cascada/appadmin/select/db?orderby=tventa.fecha> tventa.vendedor <http://127.0.0.1:8000/Cascada/appadmin/select/db?orderby=tventa.vendedor> tventa.monto <http://127.0.0.1:8000/Cascada/appadmin/select/db?orderby=tventa.monto> 3 <http://127.0.0.1:8000/Cascada/appadmin/update/db/tventa/3> 2016-05-04 Pedro 900.00 4 <http://127.0.0.1:8000/Cascada/appadmin/update/db/tventa/4> 2016-05-05 Andrés 1050.00 5 <http://127.0.0.1:8000/Cascada/appadmin/update/db/tventa/5> 2016-06-08 Pepe 123.31 6 <http://127.0.0.1:8000/Cascada/appadmin/update/db/tventa/6> 2016-06-09 Pepe 52.36 7 <http://127.0.0.1:8000/Cascada/appadmin/update/db/tventa/7> 2016-06-10 Maria 12.36 Regards. El jueves, 9 de junio de 2016, 6:29:39 (UTC-3), Ramos escribió: > > hello > how can i, via admin query a table using in the input box more than 1 > field to query? > > i tried > db.amostras.n==203027 & db.amostras.estante1=="_E_000" - >error > db.amostras.n==203027 and db.amostras.estante1=="_E_000" -> no error but > seems to search only the second field (db.amostras.estante1=="_E_000) > > how can i query based on 2 fields? > > Regards > António > > -- 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.
