On Wednesday, October 4, 2017 at 9:02:07 PM UTC-4, Leonel Câmara wrote: > > This is sort of a python question. > > Lets see exactly what this means > > query &= db.orders.status == status. > > This syntax is a python (not web2py or the DAL) shorthand for: > > query = query & (db.orders.status == status) > > > So really what you want is: > > query = db.orders.id_buyer == auth.user_id > query1 = query & (db.orders.status == status) > query2 = query & (db.orders.order_date <= initial_date) > > Thanks for reply, I did try that before but it was not giving the correct results
I tried the following query = db.orders.id_buyer == auth.user_id query1 = query & (db.orders.status == status) On printing query1, it will print "False", while I want something like print db(query1).count() -- 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.
