Re: [web2py] Reverse table look up in GAE

Ok so if i have a table in my db named homepage as below:- -- id | data | --- 1 | vivek| -- 2 | andrew| --- Now if I want to retrieve only the last row .. i can do this homepage=db().select(db.homepage.ALL,orderby=

Re: [web2py] Reverse table look up in GAE

On 9/9/2010 12:24 AM, b vivek wrote: Hi I wanted to retrieve the latest data entered in a table and thus used the below syntax for data look up homepage=db().select(db.homepage.ALL,orderby=~db.homepage.id ,limitby=(0,1)) This is expected to retrieve the last row enter