I have a field "enabled" in my scholarship table of type boolean.

In sqlite and I can do:

select name, enabled from scholarship where enabled=='T';

And I get just the enabled scholarships.

but if I do:

def scholarships():
    return 
dict(scholarship=t2.itemize(db.scholarship,nitems=10),query=db.scholarship.enabled=='T',\
        orderby=db.scholarship.id)

then all the scholarships still get listed on the web page.  Why?

Also how do I "orderby" two fields.

thx,

-wj

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to