Hi
I'm trying to use the an 'in' statement where the values are passed in by the application.

my select is as follows

select ass.comp_id.name, ass.comp_id.description
from Assignments ass
where ass.busCode in :busCodes

where :busCodes is a Collection of String objects now i have tried the following to no avail

select ass.comp_id.name, ass.comp_id.description
from Assignments ass
where ass.busCode in elements(:busCodes)

and

select ass.comp_id.name, ass.comp_id.description
from Assignments ass
where ass.busCode in (elements(:busCodes))

in both instances i don't get any error msgs but i don't get any results either but if i take the query in the hibernate logs and replace the ? manually with the coma delimited list the query works
any ideas??

use "in (:something)" and query.setParameterList()

thanks, that did the trick. i had thought that using setParameter would pickup that the param was a Collection and handle it.

Thanks again