Darn Apostrophes!!! 1

[Guest_imported]

I have a form which submits data to the database via a text field. The code works fine. But if I have an entry with an apostrophe in it like this -

Nelson's

then I get the error message

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

Is there anything I can do? I want to be able to add entries with apostrophes.

Many thanks

James

 

[NickBulka]

James,
you need to double up the apostrophes.
MyQuery = replace(MyQuery,&quot;'&quot;,&quot;''&quot [sig]<p>nick bulka<br><a href=mailto: > </a><br><a href=

http://www.bulka.com>

</a><br>Get your technical books at Bulka's Books<br>

http://www.vstorebooks.com/bulkasbooks

[/sig]

 

[KenKasmar]

Here's a nice little function that bypasses all apostrophe and quote problems:

<%Function apostrophe(strIn)
apostrophe = replace(strIn,chr(34),chr(180)&chr(180))
apostrophe = replace(apostrophe,chr(39),chr(180))
End Function%>

to use:
StrSql = &quot;insert into Table (Field) Values (&quot;
StrSql = StrSQl & &quot;'&quot; & apostrophe(Incoming_field) & &quot;')&quot;

Later,
Ken Kasmar
Red Falcon Internetworking, Inc.

http://www.redfalcon.net

[sig][/sig]

 

[EdRev]

ken,

i have the same problem querying my database. My database entries have apostrophes in them, and if I replace the apostrophe on my search string with char80, there wouldn't be any match. How do I replace the apostrophes on my database with char80, I can't seem to find that character on the keyboard. [sig][/sig]