hql query formation
Posted
by sarah
on Stack Overflow
See other posts from Stack Overflow
or by sarah
Published on 2010-06-09T06:57:26Z
Indexed on
2010/06/09
7:02 UTC
Read the original article
Hit count: 220
Hi
I want to construt a hql query like
select PLAN_ID from "GPIL_DB"."ROUTE_PLAN" where ASSIGNED_TO
in ('prav','sheet') and END_DATE > todays date
I am doing in this way but getting an error in setting parameters
s=('a','b');
Query q = getSession().createQuery("select planId from RoutePlan where assignedTo in REG ");
if(selUsers != null) {
q.setParameter("REG", s);
}
where i am doing wrong?
© Stack Overflow or respective owner