Thanks for that. Works like a bought one. (c:
Cheers
Andrew
On Mon, 2002-09-09 at 21:33, [EMAIL PROTECTED] wrote:
> 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]>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
