Hello All

I have a model structure.
*Enrollment
-->List infusions of TYPE Infusion

*Infusion
-->site of TYPE Site

I want to get Enrollments of infusions at a particular site. So my query looks something like this.

select e from Enrollment e where e.infusions.site=?

I am passing a valid site. when i try to run this query I am getting this exception

ERROR PARSER : illegal syntax near collection: site
09 Jul 2007 16:44:29,940 ERROR PARSER : <AST>:0:0: unexpected end of subtree
09 Jul 2007 16:44:29,940 ERROR PARSER : left-hand operand of a binary operator was null
09 Jul 2007 16:44:29,940 ERROR PARSER : <AST>:0:0: unexpected end of subtree
09 Jul 2007 16:44:29,955 ERROR PatientsController: org.springframework.orm.hibernate3.HibernateQueryException: illegal syntax near collection: site [select e from Enrollment e where e.infusions.site=? ]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: illegal syntax near collection: site [select e from Enrollment e where e.infusions.site=? ]

Hi
plz check the query once again..

select

Quote:

"e"

from Enrollment e where e.infusions.site=?
what is that e refers too

here e refers to the enrollment

here e refers to the enrollment