I am trying to do a LIKE comparison in the WHERE clause of my search.

I create my criteria like so:

  String searchString = "foo";
  Criteria crit = new Criteria();
  crit.add("TURBINE_USER.LAST_NAME", (Object) searchString,
Criteria.LIKE );

When I do a toString() on the criteria it gives me 

  SELECT  FROM TURBINE_USER WHERE (TURBINE_USER.LAST_NAME = 'foo') 

I dug through the code and it looks like TurbineUserPeer doSelect method
feeds the BasePeer doSelect which calls createQueryString to build the 
query from the criteria.  I do not see anywhere in createQueryString
where it would include any comparisons.

Am I missing something. Is this the correct way to do a "LIKE"
comparison?
I think I am doing same thing that the criteria doc example shows. I am
using code from the CVS HEAD of about 3 weeks ago. It builds the 
turbine-2.2-dev.jar.  I would appreciate any pointers someone could give
me.

-- Steve Davis

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to