> > query=> [
> > first_name=> { lower=> 'john' },
> > last_name=> { upper=> 'DOE' },
> > ]
>
> just to add-- i know i can approximate that with an ILIKE and then
> parse the result set. i'm looking to specify the case on certain
> things though.
Kind of off topic, but I was just looking to do some case insensitive
searching myself and couldn't figure it out. I remembered this post
mention ILIKE and it magically worked. I notice it's not in the
QueryManager docs as a supported OP type though.
-------------------------------------------------------------------------
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
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
