Hmm, I tried a similar query and it properly respects both ~'s. Can you pack and attach a minimal app (using SQLite) that exhibits the problem?
Anthony On Sunday, May 13, 2012 9:14:27 AM UTC-4, BlueShadow wrote: > > > def index(): > rows=db().select(db.article.ALL, orderby=~db.article.submitted|~db. > article.views, limitby=(0,5)) > return dict(Articles=rows) > > Thats my code from the default.py > removing and adding the second ~ doesn't change anything. > in my index.htm I simply print the Titles and views with a for loop. > > > On Sunday, May 13, 2012 3:03:30 PM UTC+2, Anthony wrote: >> >> orderedby=~db.article.date|~db.article.views >> >> should work. Did you try exactly that code? >> >> Anthony >> >> On Sunday, May 13, 2012 4:43:24 AM UTC-4, BlueShadow wrote: >>> >>> Hi I got A table for articles on my page wich contains a variable for >>> the date it was submitted and the number of views (content title...) >>> I tried to do a select which gives me the newest five of this table >>> (orderedby=~article.date) Now I want to sort those five by the number of >>> views. >>> I tried it with appending the ordered by with |article.views and with >>> |~article.views but the result is the same I get the newest five sorted by >>> views but with the least views first. >>> I know I could reverse the order with some lines of python code but >>> there must be a simple way to do it. >>> >>
