0 Replies Latest reply on Nov 20, 2006 3:05 PM by Roy Crosland

    EJB QL (2.1), passed parameters to IN predicate in WHERE cla

    Roy Crosland Newbie

      I have a CMP finder method whose WHERE clause has the fragment: ...WHERE d.value IN (?1)...
      If I pass a simple string parameter (eg, "you") in to the method, the search works. But if I pass something like "'you', 'me', 'them'" the search fails.
      If I hard-code the multi-word string in to the finder method (eg, ...WHERE d.value IN ('you', 'me', 'them')...), I get the expected results. So it fails because I'm passing the multi-word string as a parameter.
      Is there a special way of passing in such a parameter?
      cheers
      Roy