Sorry for the late reply Martin, but even if I add the datetime field in
here,and order by the datetime field , wont I get the data
in ascending order . However I did what you had suggested , But i still am
able to retrive the data in ascending order rather than descending.
Could there be any other method ..
(A quick recap--> I am trying to get the data ordered in descending order
from the dbase. It can be done by using a tilde , but the GAE seems to
ignore the tilde all together.. Please help)
On Thu, Sep 9, 2010 at 3:46 PM, Martin.Mulone <mulone.mar...@gmail.com>wrote:
> Yes but i think this is gae thing. You try? with max(id) or add some
> datetime field and order by this field like Field('created_on',
> 'datetime',
> default=datetime.datetime.today(),writable=False,readable=False)
>
> On 9 sep, 03:06, b vivek <bvivek1...@gmail.com> wrote:
> > 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/
>
