I have rebuilt the function from scratch:
def byplace():
records=db((db.company.id==db.address.company)&(db.company.id==db.companyLOB.company))
\
.select(db.company.companyName,db.company.ranking,db.address.streetName,db.companyLOB.lineOfBusiness,
\
orderby=db.company.ranking|db.company.companyName)
return dict(records=SQLTABLE(records))
That narrows my question down to the WHERE clause:
WHERE address.cityname='Eindhoven' AND address.typeofaddress=1 AND
companyLOB.lineOfBusiness=1.
It seems to conflict with the join:
db((db.company.id==db.address.company)&(db.company.id==db.companyLOB.company))
Furthermore, while reading the manual I came across the following
line:
thispage=db.(db.page.id==request.args[0]).select() [0]
and I wonder what the last [0] means.
Annet.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
