On Sun, Sep 10, 2006 at 11:01:48PM +0200, Andres Freund wrote:
> Currently sqlboject uses LIKE for all its comparisons which is case sensitive
> in some databases (eg. postgres) (I _think_ this is standard compliant, im on
> the road currently, so i cant check) others do not (eg mysql).
> At least I sometimes need a case sensitive LIKE and sometimes not. Is there
> interest in changing sqlobject to support both? Eg. either having something
> like .istartswith(str) or .startswith(str, casesensitve = False)?
Why not just
from sqlobject.sqlbuilder import func
func.lower(MyTable.q.field).startswith(str.lower())
???
And how are you going to implement
.startswith(str, casesensitve = True)
on MySQL? ;)
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
