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