paramedic schrieb:
> I am trying to add a search section in my tubogears web application. I
> want the search to be case insensitive try to use the like statement
> in sqlobject however I could not achive.

SomeModelObject.select(sqlobject.LIKE(SomeModelObject.q.foo, '%bar%'))

However, there is no ILIKE, since it's only supported by some database
backends.

Chris

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to