Hi everyone - I have a fairly simple query with an 'IN' clause:



I have tried binding the following to :zipCodeList in my code, all of which returned no results and threw no errors:

1.) a comma delimited list of zipCodes
2.) a comma delimited list of single-quoted zip codes
3.) a List object containing String objects (the zip codes)


Any ideas how to get an HQL query with an IN clause to return some results?

I'm an idiot....or the documentation could use a little work....

http://forum.hibernate.org/viewtopic.php?t=929302

I'm sure your question is answered by now, but this might help someone else.

If myObject.getZipCode() returns an object, the way you do an 'in clause' is like so:



where getZipCode().getId() returns the ZipCode's Hibernate id. Then you bind a List of ZipCode ids to :zipCodeList.

Hope that helps,
Bobby Martin
Legerity Group
Frimp.net