Re: [web2py] Re: Reverse table look up in GAE

2010-09-10 Thread b vivek
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

Re: [web2py] Re: Reverse table look up in GAE

2010-09-10 Thread b vivek
It would be great if somebody could please let me know how to find the id of the last inserted row in a table using DAL On Fri, Sep 10, 2010 at 4:09 PM, b vivek bvivek1...@gmail.com wrote: Sorry for the late reply Martin, but even if I add the datetime field in here,and order by the datetime

Re: [web2py] Re: Reverse table look up in GAE

2010-09-10 Thread b vivek
Oh Thanks I got it ... the solution suggested by Martin works perfectly instead of ordering by record id ,it should be ordered by datetime field and the tilde works fine! On Fri, Sep 10, 2010 at 4:23 PM, b vivek bvivek1...@gmail.com wrote: It would be great if somebody could please let me know

[web2py] Re: Reverse table look up in GAE

2010-09-10 Thread howesc
please correct me if i am wrong, but ID's on GAE are really UUID's and are not sequential and not guaranteed to be strictly increasing. timestamps are the closest you can get to strictly increasing on GAE, but it is possible for 2 inserts to happen at the same time, so don't count on that 100%

[web2py] Re: Reverse table look up in GAE

2010-09-09 Thread Martin.Mulone
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