<div>
If you have a string like this :<br />
<br />
&lt;%MyString=&quot;men's thoughts&quot;%&gt;<br />
<br />
and you insert it into the database, do it like this:<br />
<br />
&lt;%sql=&quot;insert into tablename (fieldname) values ('&quot;&amp;server.htmlencode(MySt<wbr />ring)&amp;&quot;')&quot;<wbr />%&gt;<br />
<br />
The function server.htmlencode handles the apostrophe, when you read it from the database you don't need to do anything<br />
<br />
Hope it helps you<br />
<br />

</div>


If you have a string like this :

<%MyString="men's thoughts"%>

and you insert it into the database, do it like this:

<%sql="insert into tablename (fieldname) values ('"&server.htmlencode(MyString)&"')"%>

The function server.htmlencode handles the apostrophe, when you read it from the database you don't need to do anything

Hope it helps you



<div>
I think I get what you mean but the database is not updated online; it is converted from some other format, then uploaded.<br />

</div>


I think I get what you mean but the database is not updated online; it is converted from some other format, then uploaded.


<div>
Could you provide more information then ?<br />
cos a normal select wouldn't be doing difficult on it...<br />

</div>


Could you provide more information then ?
cos a normal select wouldn't be doing difficult on it...


<div>
Just a normal select on a normal access table.<br />
<br />
Keywords = Request.form(&quot;Keywords&quot;)<br />
q = &quot;SELECT * FROM dbase WHERE Keywords LIKE '%&quot; &amp;&nbsp;Keywords &amp;&nbsp;&quot;%&quot;<br />
(Actually a little more complex but essentially the same)<br />

</div>


Just a normal select on a normal access table.

Keywords = Request.form("Keywords")
q = "SELECT * FROM dbase WHERE Keywords LIKE '%" & Keywords & "%"
(Actually a little more complex but essentially the same)


<div>
- or -<br />
<br />
&lt;%<br />
MyString = replace(MyString, &quot;'&quot;, &quot;''&quot;)<br />
%&gt;<br />
<br />
repace the single' with two ''. &nbsp;This will also work...<br />

</div>


- or -

<%
MyString = replace(MyString, "'", "''")
%>

repace the single' with two ''.  This will also work...


<div>
Massey,<br />
You're a star.<br />
Nick<br />
-grab points<br />

</div>


Massey,
You're a star.
Nick
-grab points


<div>
<div class="content wysiwyg-content">
When I use an apostrophe as part of a serch term - eg:<br />
&quot;men's thoughts&quot;<br />
I get a syntax error returned.<br />
What is the workaround without replacing these in the database and then replacing them back in the search results?<br />
Cheers
</div>
</div>


When I use an apostrophe as part of a serch term - eg:
"men's thoughts"
I get a syntax error returned.
What is the workaround without replacing these in the database and then replacing them back in the search results?
Cheers

apostrophe in asp search

Web development includes all aspects of presenting content on intranets and the Internet, including delivery development, protocols, languages and standards, server software, browser clients, databases and multimedia generation.