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.

Reply via email to