Issues with search terms containing apostrophe

Results 1 to 2 of 2

Thread: Issues with search terms containing apostrophe

  1. #1
    Join Date
    Dec 1969

    Default Issues with search terms containing apostrophe

    Hi all.. dunno where better to post this but here&#039;s my problem.. I&#039;m running a large query against SQL using some stored procs. It&#039;s driven by a search box on my site... when a user tries to search with something that has quotes, like women&#039;s it doesn&#039;t return anything. However when I try to run it under the Query Manager in SQL, and replace the single &#039; with two &#039;&#039; I get results.<BR><BR>What I did then was to use this line:<BR>sSearchString = Replace(trim(Request.QueryString("search")), "&#039;", "&#039;&#039;")<BR>to automatically replace the &#039; with &#039;&#039; before it ran the search. However it&#039;s still not doing it... as far as I can see, it is doing the replacement just fine but sql still won&#039;t return any values.<BR><BR>Is there anything I can try or that anyone can suggest? It&#039;s becoming a rather large issue here at work. Much appreciated!<BR><BR>-Ko

  2. #2
    Join Date
    Dec 1969

    Default Looks OK

    What you&#039;re doing should work - try posting what the sSearchString value is (or better yet the entire SQL statement that you&#039;re sending).....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts