openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daryl Stultz <daryl.stu...@opentempo.com>
Subject Re: Case indifferent query
Date Thu, 17 Jun 2010 12:13:26 GMT
On Thu, Jun 17, 2010 at 7:58 AM, gilbertoca <gilbertoca@gmail.com> wrote:

>
> I think this[1] reference can help.
>
> The examples for these functions all use "=" as the operator. I need "IN".
I don't think there is any problem with my usage of lower() as this works:

select o from User as o where
lower(o.userCode) = 'ab' or lower(o.userCode) = 'cd'

Do I have to iterate over my collection and build this up with OR or is
there a way to do this with IN?

-- 
Daryl Stultz
_____________________________________
6 Degrees Software and Consulting, Inc.
http://www.6degrees.com
http://www.opentempo.com
mailto:daryl.stultz@opentempo.com

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message