Dealing with apostrophe (‘) problem in asp.net, sql server, oracle dat

home
asp.net
view story

3 Kicks

Dealing with apostrophe (‘) problem in asp.net, sql server, oracle dat(dotnetspidor.blogspot.com)

submitted by sangam100(357) 3 years, 2 months ago

The use of apostrophe (') character as an input text in an sql query troubles the query operation. Say, you have a textbox in which user can input her search text and she inputs "john's" as her search text. Now your employee query will look like: So I have explained the solution to this universal problem. This may occur anywhere in any database query: sql server , oracle of mysql. <a href="http://dotnetspidor.blogspot.com/2008/11/dealing-with-apostrophe-problem-in_28.html">So here goes the handy solution</a>

add a comment |category: ASP.NET |Views: 89
Tweet