[Persistence, JBoss/CMP, Hibernate, Database] - Re: HQL and enum constants - jboss-user

Thursday, 22 February 2007

Hi.

try this:

SELECT DISTINCT m FROM Material m, IN(m.suppliers) s WHERE m.unit <>
Material$MaterialUnit.SQUARE_METRES AND s.id = :id

I am not sure if you will need the package name before Material.

Cheers,

Andy

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

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