.Net error with Searching if special sign ‘ is used in search
Like to make it possible that you can search O´Neill on our homepage and MS-SQL error the search/page.
What do we need to add to our Searchfield to allow this ? Here our search page today:
<%
if request("ArticleNo")<>"" then
ArticleNo = request("ArticleNo")
else
ArticleNo = "Artikel Nr."
end if
if request("search")<>"" then
search = request("search")
if IsNumeric(search) then
ArticleNo = search
search = "Freitextsuche"
end if