def scholarships():
return dict(scholarship=t2.itemize
(db.scholarship,nitems=10,query=db.scholarship.enabled=='T',\
orderby=db.scholarship.id|db.scholarship.otherfield))
On Dec 5, 11: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
-~----------~----~----~----~------~----~------~--~---
