Thanks kannikkatt, No I did not want it plain and simple. And your example is not what I was asking. Thanks for the effort anyway...
I need to combine 2 fields like this last_name + ' ' + first_name and then use Criteria.LIKE with IgnoreCase set to true. Any ideas? It may be B&W for you but certainly not for me yet :-) with best wishes, Taavi ----- Original Message ----- From: "Shine Kannikkatt" <[EMAIL PROTECTED]> To: "'Turbine Torque Users List'" <[EMAIL PROTECTED]> Sent: Friday, August 09, 2002 1:23 PM Subject: RE: criteria: how to write this? > Dear TT, > > u shud be reading the tutorial & api more - minimal tho they are > (why is it we always want everything laid down in B&W? thank god for openS > projects - cuts boredom, reduces cost and improves quality. What say?) > anyway some pointers.... > Criteria crit = new criteria(); > crit.add( xxxPeer.LAST_NAME, (Object)"?" , Criteria.LIKE); > crit.or( xxxPeer.FIRST_NAME, (Object)"?", Criteria.LIKE); > crit.setIgnoreCase(true); > > > ..experiment.............:-) > kannikkatt -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
