[web2py] "Simple query" suffers nasty case of user error...

[Tom Campbell]

...but I'm too much of a noob to get it.

# file models/db_todo.py
db.define_table('todo',
        Field('summary','string',requires=IS_NOT_EMPTY()),
        Field('priority',requires=IS_IN_SET([1,2,3,4,5])),
        Field('complete','boolean',default=False))

# file views/main/index.html
{{extend 'layout.html'}}
<h2>Current tasks</h2>
{{=grid}}

# file controllers/main.py
@auth.requires_login()
def index():
        # Show only remaining tasks
        todos = db(db.todo.complete==False).select()
        grid=SQLFORM.smartgrid(db.todo,todos)
        return dict(grid=grid)

1. The main/index.html view is meant to show only completed tasks
(completed==False). It shows all of them.

2. The dropdowns for Priority start with a blank slot, not 1.