[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - How do you do a where column in ( .... in EJB-QL

[kasim]

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



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4183520#4183520

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4183520