Oops - I didn't have the query and sortby inside the itemize parens - now it works!
-wj On Fri, Dec 5, 2008 at 10:48 AM, Wes James <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---

