on GAE the record ID is not a column and cannot be used for sorting or in queries.
db(db.table.id==id) and db(db.db.table.id>0) are in fact implemented in web2py in a special way. I agree we need better documentation. Robin is the master on this topic. Perhaps he can help us. Massimo On Jan 15, 6:23 am, "Markus Gritsch" <m.grit...@gmail.com> wrote: > Hi, > > is there some detailed information available on which DAL subset is > available on GAE? > > The web2py book says that "You cannot perform complex queries on the > datastore, in particular there are no JOIN, OR, LIKE, IN, and > DATE/DATETIME operators". > > I used a query with an orderby=~db.person.id which did not work on > GAE. Although tables do have an id column which can be uses to select > a row, it cannot be used for orderby. I worked around this by an > additional datetime column, however, I wonder which other stuff does > also not work on GAE. > > Kind regards, > Markus --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---