tags:

views:

96

answers:

0

Hi,

I'd like to make a query with WHERE MEMBER OF.

This is my query

SELECT DISTINCT pav FROM EPCI AS epci, IN (epci.listTown) AS town, IN (town.listPAV) pav WHERE epci.id = ?1 AND pav.flag = :flag AND pav.oneLocalisation.status MEMBER OF :status ORDER BY pav.name

Status is an ENUM and :status a list of enum

List<Status> listTmp = new ArrayList<Status>();
listTmp.add(Status.create);
listTmp.add(Status.update);
query.setParameter("status", listTmp);

When i run I have an exception

Internal Exception: line 1:171: expecting IDENT, found ':status'

Thanx for your help

Shucky