Your syntax error comes from a missing closing parenthesis ')' just
before the return:
orderby=db.company.ranking|db.company.companyName) ) # <---
On Oct 23, 5:22 am, annet <[EMAIL PROTECTED]> wrote:
> I have got the following SQL query which I need to rewrite as a web2py
> function:
>
> SELECT company.companyname, streetname
> FROM company
> JOIN address ON company.id=address.company
> JOIN companyLOB ON company.id=companyLOB.company
> WHERE address.cityname='Eindhoven' AND address.typeofaddress=1 AND
> companyLOB.lineofbusiness=1
> ORDER BY company.ranking;
>
> The rewritten code:
>
> def byplace():
>
> clubs=db((db.company.id==db.address.company)&(db.company.id==db.companyLOB.company),
> \
>
> (db.address.cityName=='Eindhoven')&(db.address.typeOfAddress==1)&(db.companyLOB.lineOfBusiness==1)\
> .select(db.company.companyName,db.company.ranking,db.address.streetName,
> \
> orderby=db.company.ranking|db.company.companyName)
> return dict(clubs=SQLTABLE(clubs))
>
> When back in design I click on byPlace I get a SyntaxError:
>
> Traceback (most recent call last):
> File "/Library/Python/2.5/site-packages/web2py/gluon/restricted.py",
> line 61, in restricted
> else: ccode=compile(code.replace('\r\n','\n'),layer,'exec')
> File "/Library/Python/2.5/site-packages/web2py/applications/b2c/
> controllers/clubs.py", line 20
> return dict(clubs=SQLTABLE(clubs))
> ^
> SyntaxError: invalid syntax
>
> 'Eindhoven' is entered for testing purposes, and should be replaced
> with an auto-complete field, in which the user types a city name.
>
> I hope one of you can point me in the right direction to solve this
> problem.
>
> Best regards,
>
> 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
-~----------~----~----~----~------~----~------~--~---
