hi,
i have a parameter which filters product name and its multi value property is true.when i select only one product from parameter it works.but when i select multiple value or select all it gives incorrect syntax near ','.Can you help me please?
i have a parameter which filters product name and its multi value property is true.when i select only one product from parameter it works.but when i select multiple value or select all it gives incorrect syntax near ','.Can you help me please?
1 Answer, 1 is accepted
0
Teoman
Top achievements
Rank 1
Rank 1
answered on 15 Jan 2012, 05:41 PM
i fixed my problem like this.when you use IN in query.you have to use it like it.
WHERE (NAMESURNAME IN(@NAMESURNAME))
WHERE (NAMESURNAME IN(@NAMESURNAME))