HQL List Parameter

Noel · **Joined:** Thu Aug 14, 2008 1:09 pm **Posts:** 2

Hi, I am trying to pass a list of integers into an HQL statement:

Code:

SELECT schedule
from BillableSchedule as schedule
where schedule.Id in :scheduleIdList

I have tried passing :scheduleIdList as an array of ints and also as a list. When I turn on SQL Profiler, I see the parameter is passed in as varbinary data. The documentation shows that this is supported:

Code:

from Eg.DomesticCat cat where cat.Name in ( 'Foo', 'Bar', 'Baz' )

Is there a way to do the same thing with a list of items as a parameter:

Code:

from Eg.DomesticCat cat where cat.Name in :fooBarList

Thanks!

Noel

wolli · **Posted:** Thu Aug 14, 2008 2:26 pm

Try

"from Eg.DomesticCat cat where cat.Name in (:fooBarList)"

and

query.SetParameterList(list);

Noel · **Joined:** Thu Aug 14, 2008 1:09 pm **Posts:** 2

I was just about to post that I found my problem. My two issues were those that you described:

1.) I was using SetParameter instead of SetParameterList. This was causing the varbinary issue. I didn't see the SetParameterList operation because I am using a light wrapper around nHibernate that didn't expose the SetParameterList method.
2.) There was a syntax error in the HQL (I hadn't wrapped the parameter in parenthesis.

Thanks very much for you accurate and speedy response!

Best,
Noel