hi andrew,
have you tried adding UPPER to the field name ?
ie. crit.addEqualTo("upper(firstname)", "ANDREW")
ojb will extract "firstname" and use the db column instead,
resulting in something like this:
where ... upper(fname) = 'ANDREW'
hth
jakob
> Howdy,
>
> I have a need to implement case insensitive queries. In my application,
> I need to store certain names in a case sensitive fashion, but need to
> validate them ignoring case (I really don't want to store a second
> lowercase version of the field).
>
> In searching I figured I could use criteria.addSqlCriteria(..) but I
> really really want to use field names and not table columns.
>
> Before I go and try to implement a CaseInsensitiveFieldCriteria, is
> there a better way to go??
>
> Thanks and cheers
> Andrew
>
>
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
