0 Replies Latest reply on Oct 21, 2008 10:01 AM by Joseph Nusairat

    How do you do a where column in ( .... in EJB-QL

    Joseph Nusairat Newbie


      So not sure if this question should be in here or the EJB 3 section but i can't seem to find the answer to this if there is one.

      I basically have for my named query -

      select e from TABLE where column in (:stuff)

      ... now how do i populate stuff? It wont acccept an array, if i pass a comma separated string i am pretty sure its encompassing that as one

      I know with Criteria Queries i do Expression.In .... but cant seem to figure out what it is in EJB_QL ... is there a way? Or do i need to a native query?

      thanks