I reinstalled it, and it all works. But here is another question: i have some 100,000 entries (im writing Chinese-> English dictionary), and based on the documentation, the above solutions pulls all the records and lets python filter them down. This takes a long time.
Looking at the Google docs in http://code.google.com/appengine/docs/python/datastore/queriesandindexes.html it has provided a limited solution: db.GqlQuery("SELECT * FROM MyModel WHERE prop >= :1 AND prop < :2", "abc", u"abc" + u"\ufffd") It allows me to search for entries with a given prefix, how can i directly invoke gql from my data model. And off top of you head, would that allow the datatable to do the filtering? Also how can i make sure that a specific property is indexed? On Nov 4, 10:34 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > I think something is wrong with your installation. Can you try > reinstalling web2py? > > On Nov 4, 8:21 am, mike <michal...@gmail.com> wrote: > > > > > Im currently only using mysql, localy, not yet on GAE > > > On Nov 3, 5:18 pm, "mr.freeze" <nat...@freezable.com> wrote: > > > > Does it work locally but not on GAE? I am using the same version with > > > no problems locally. > > > > On Nov 3, 2:46 pm, mike <michal...@gmail.com> wrote: > > > > > Version 1.71.0 (2009-10-31 01:13:28) > > > > > On Nov 3, 3:42 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > Do you have the latest web2py version? Probably not. > > > > > > On Nov 3, 2:36 pm, mike <michal...@gmail.com> wrote: > > > > > > > Im following the documentation, I have made this model (copy&paste > > > > > > it): > > > > > > > buyer = db.define_table('buyer', > > > > > > Field('name')) > > > > > > > and in my control, i try to do this: > > > > > > > rows = db(buyer.id>0).select().find(lambda > > > > > > row:row.name.startswith > > > > > > ('C')) > > > > > > > return dict(rows) > > > > > > > but im getting this error: > > > > > > > AttributeError: 'Rows' object has no attribute 'find' > > > > > > > any suggestions? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" 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 -~----------~----~----~----~------~----~------~--~---
