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.


Reply via email to