GAE now has support for query and orderby id, but nobody has exposed it to the DAL yet! If you do a search for "__key__" on the web2py mailing list, you can see that I have pointed this out over 3 times.
http://code.google.com/appengine/docs/python/datastore/queriesandindexes.html#Queries_on_Keys All GAE datetimes are UTC (no timezone info). For the sake of caching, I would render all html dates as UTC, then use javascript/ jquery to rewrite the UTC dates as local time based on the browser's timezone. Robin On Oct 17, 11:51 am, mdipierro <[email protected]> wrote: > I order to do this, upon login, the client must send the server and > hours different between localtime and gmt. The server should then take > into account the difference when reporting time. > > Massimo > > On Oct 17, 11:05 am, BearXu <[email protected]> wrote: > > > Is there any good solution to translate the timestamp in the server to > > client's timezone and return it? > > > 2009/10/17 mdipierro <[email protected]> > > > > Make sure to timestamp with the GMT and not the local time. > > > > On Oct 17, 9:36 am, BearXu <[email protected]> wrote: > > > > If the Google servers are distributed globally, is that possible that I > > > get > > > > different time from different servers in different countries? > > > > > 2009/10/17 mdipierro <[email protected]> > > > > > > You can orderby but not by id. GAE does not support that and the id on > > > > > GAE are not sequential anyway. You need to timestamp records and order > > > > > by timestamp. > > > > > > On Oct 16, 6:46 pm, BearXu <[email protected]> wrote: > > > > > > Actually I want to desc orderbut the orderby=~db.table.id is also > > > wrong > > > > > > > 2009/10/17 BearXu <[email protected]> > > > > > > > > if I write this into my select command using dev_server, it is > > > wrong. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
