Hi,
i have used rad grid with filtering in our project.
This implementation works perfectly except in below mentioned scenerio:
We want filters to implement like queries on grid.
So we have set query as :
([<column value>] like '% <Filter value> %')
But this scenerio does not work when single quote comes in filter value.
It seems we might need to compare encoded values, but i am not to sure how to achieve this as syntax is sql like and i relaly doubt that wheather HtmlEncoding will work in this scenerio?
i have used rad grid with filtering in our project.
This implementation works perfectly except in below mentioned scenerio:
We want filters to implement like queries on grid.
So we have set query as :
([<column value>] like '% <Filter value> %')
But this scenerio does not work when single quote comes in filter value.
It seems we might need to compare encoded values, but i am not to sure how to achieve this as syntax is sql like and i relaly doubt that wheather HtmlEncoding will work in this scenerio?