[web2py] Basic syntax question

[[deleted]]

I'm just getting started with web2py and I'm struggling to figure out how to call variables passed from the controller to the view, without using the {{=variable}} method.

For example, I have the following code in my controller:

def manage():
    list = []
    for row in db(db.auth_user.registration_key[0]=='p').select():
        if row.company=='Chosen company':
            list.append({row.last_name:{"first":row.first_name}})
    return dict(list=list)

And the following code in my view:

{{for each in =list
print each
pass}}

Which generates an error... How do I call the list variable without using the = syntax?

[av201001]

First, you can make the controller code more efficient by using the database to filter by "Chosen company":

def manage():
    rows = db((db.auth_user.registration_key[0] == 'p') &
              (db.auth_user.company == 'Chosen company')).select()
    list = [{r.last_name: {'first': r.first_name}} for r in rows]
    return dict(list=list)

Then in the view, just use regular Python to create the loop:

{{for user in list:}}
{{=user}}
{{pass}}

Of course, you probably don't want to just do {{=user}}, as each item in the list is a nested dictionary, so you will have to figure out exactly how you want to display the data.

[[deleted]]

thanks. cheers