Using Multi Valued Parameters with the SqlDataSource component

[Mario]

Hi,

I'm trying to pass a parameter value to the sql query like described in the KB article. Sample:

SELECT * FROM Person.Contact WHERE FirstName = @FirstName
This works fine, but if I try with a multi valued parameter, the query gives no results:
SELECT * FROM Person.Contact WHERE FirstName IN (@FirstName)
Any ideas? Thanks in advance.

[Neli]

Hello Mario,

Indeed, you need to use the IN operator. You can take a look at the following articles:

- Using Multivalue Parameters

- How to use MultiValue Report Parameter in a SQL query

 

Regards,
Neli
Progress Telerik