Entitydatasource filter with IN clause

Question

User-867857476 posted

hello guys,

i want to filter Entitydatasource  by a list of number but i got this error

The query syntax is not valid. Near term ',', line 6, column 48.

what is wrong with this code?

BookEntityDataSource.Where="it.CategoryId_FK=@Cat||it.CategoryId_FK IN (1,3,11,8,6,7,10,95,4,5)";

Answer 1

User-1538479794 posted

Hi

The query syntax is not valid. Near term ',', line 6, column 48.

That is because that you sql statement has some exception

so please try to chang || to or as follow code :

 BookEntityDataSource.Where = "it.CategoryId_FK=@Cat"+"or"+"it.CategoryId_FK IN (1,3,11,8,6,7,10,95,4,5)";

Best Regards,

May

Answer 2

User-867857476 posted

thanks May-song, i try your answer but i still get "The query syntax is not valid. Near term ',', line 6, column 48" error

Answer 3

User-867857476 posted

any body?

Answer 4

User-158764254 posted

try swapping your parenthesis to curly braces

it.CategoryId_FK IN {1,3,11,8,6,7,10,95,4,5}