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
-----Original Message-----
From: Taavi Tiirik [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 07, 2002 5:42 PM
To: [EMAIL PROTECTED]
Subject: criteria: how to write this?
Hello,
I am doing my very first steps with Torque. Please, if there
is an easy way how to create a following criteria, please
point me in the right direction.
upper( last_name || ' ' || first_name ) like upper( ? )
Given parameter can be something like this:
"%Smith J%" => returns all John Smiths,
"%john%" => returns all Johns, etc.
with best wishes,
Taavi
--
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]>
