the form does a get to an aspx datagrid written in c# (i did not write this and i need to only modify it until i have time to redo the entire thing so please dont say its all wrong, i know lol)
the filter for the specialty is a loop statement using if...
Expand|Select|Wrap|Line Numbers
- if (Server.HtmlEncode(arr1[loop1])=="specialty")
- sWhere += "specialty LIKE '%" + (arr2[loop2])+ "%' AND ";
- if (Server.HtmlEncode(arr1[loop1])=="specialty2")
- sWhere += "specialty LIKE '%" + (arr2[loop2])+ "%' AND ";
basically i need to change it so that if specialty2 is selected it will filter by both
wha ti have above works but if both are selected....instead of filtering by both..i get no results.