Thanks M; I'll have a look at your new solution. Any performance issues that you know of?
On Friday, January 8, 2010, mdipierro <[email protected]> wrote: > http://groups.google.com/group/google-appengine-python/browse_thread/thread/ceebac3397625019/e2682c5ba67ce48e?lnk=gst&q=lower#e2682c5ba67ce48e > > On Jan 8, 3:08 pm, Carl <[email protected]> wrote: >> Ah! >> >> GAE doesn't support lower()http://osdir.com/ml/web2py/2009-10/msg00625.html >> >> On Jan 8, 1:06 pm, Carl <[email protected]> wrote: >> >> > hi, >> >> > Locally, on sqlite I am using the following calls to determine if a >> > team name already exists in a database fine: >> >> > in a constructor: >> > self.db = db >> >> > in a class method: >> > n = self.db(self.db.team.name.lower() == name.lower()).count() >> >> > when run on dev_appserver (GAE) self.db.team.name.lower() throws an >> > exception. >> >> > A work-around would be to store a display version in an additional >> > field and then convert to lowercase when inserting into the database. >> >> > Does anyone know of a more elegant solution/approach? >
-- 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.

