Multi-Value parameter with "Allow Null" = True results in SQL error when multiple values selected ...

[Wayde]

I have a multivalue parameter named "@CountryID" with the "Allow Null" property = True.  Works fine if I select the null checkbox or select a single value.  BUT, when I select multiple values I get a SQL exception.

SQL to look like this:

"select * from Countries where CountryID IN (isnull(@CountryID,CountryID))"

The error I get when I pass in MULTIPLE VALUES is ... "The isnull function requires 2 argument(s)"

I'm not sure what is happening here ... but it looks like when multiple values are specified the @CountryID isn't being set to something like "1,2,3" as I would expect.

Thanks - Wayde

[Steve]

Hello Wayde,

Your question has already been answered in the other thread you've opened. Please, see our answer there for more information.

Regards,
Steve
the Telerik team