In the following function, the idea is to select a club's data based
on the id in request.args. Then if the club's status is 0 (the field
is of type string) the function should redirect to an other
application, else the address and nfa data should be selected from the
database and returned to the details view.


def details():
    id=request.args[0]
    club=db(db.bedrijf.id==id).select(db.bedrijf.ALL)
    if club[0].bedrijf.status=='0':
        redirect(URL(a='site',c='default',f='index',args=id))
    else:
        address=db((db.adres.bedrijf==id)&
(db.adres.adressoort=='Vestigingsadres')).select()
        nfas=db((db.bedrijfnfa.bedrijf==id)&
(db.bedrijfnfa.nfatype==db.nfatype.id))\
        .select
(db.bedrijfnfa.nfatype,db.bedrijfnfa.adres,db.nfatype.nfatype,orderby=db.bedrijfnfa.nfatype)
    if not club and address and nfas: redirect(URL
(r=request,f='byplace'))
    return dict(club=club[0],address=address[0],nfas=nfas)


This function is not working, the error references the if statement, I
have been tinkering with it, but then, even though the status of a
club is not 0 the function redirects.

What am I doing wrong?


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 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to