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=~db.homepage.id,limitby=(0,1)) Now let me point out that this works prefectly on localhost using the normal rdbms like mysql or sqlite. However when I use the local development GAE environ or even when I upload it to GAE,it just returns the first row. Seems like it totally ignores the tilde. The same command when used on GAE gives me the first row,rather than the last one. Thanks Vivek On Thu, Sep 9, 2010 at 11:27 AM, Andrew Thompson <andre...@aktzero.com>wrote: > 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 entered in the table homepage . > While this works perfectly, it does not work on GAE. It would be really > helpful, if someone could please help me with this.. > > > While I'm not familiar with GAE, I can say for sure that you've not > provided enough information. > > How does it "not work"? > > For example, can you make any .select() work? If you remove the orderby or > the limitby does it change how it doesn't work? > > -- > Andrew Thompsonhttp://aktzero.com/ > >
