I put up this line rslts=db((db.business.place==results.id) & (db.business.services==request. vars.services_id)).select() The good thing is i am not getting any errors anymore but now the page is displaying nothing at all! I am not getting any results in my view
*CONTROLLER* def Results(): results=db.locations(request.args(0)) rslts=db((db.business.place==results.id) & (db.business.services== request.vars.services_id)).select() services=len(rslts) return locals() *VIEW* {{extend 'layout.html'}} {{for company in rslts:}} The company is: {{=company.rslts}}<br /> {{pass}} On Thursday, March 28, 2019 at 1:23:20 PM UTC+2, Leonel Câmara wrote: > > Just send the services id in the URL either as an arg or a var and then do > something like this: > > rslts=db((db.business.place==results.id) & > (db.business.services==request.vars.services_id)).select() > > Notice that I also removed a query you had in the select call, which was > wrong. > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.