Character Conversion

Hello,

I need to input into an Access database a string. My problem occurs when the string that I grab from an HTML form has a ' in it.

I understand why it is doing it. However I do not understand how to fix it.

My question is, how do you grab a string from an ASP page such as: "Hello what's up" and place it into an database through ADO. The problem is the single quote. I know how to insert values into a database.

Thank-you

What kind of database you are using ?

In MySQL for example there is an escape character backslash ( \ ) which allows you to work with some special characters in a string:
I think there must be an equivalent in MSSQL or others.

For MySQL:
\\' A single quote character.
\" A double quote character.
\b A backspace character.
\n A newline character.
\r A carriage return character.
\t A tab character.
\\ A backslash character.

First you have to replace all single quotes in your strings to ( \\' ) and than insert them to database:

I'm using an Access Database

It is same with MySQL...

You can use the info in my first post

I already tried using replace(str, "'", "\'")

However, when I use this, and I try to Update the information in the database, I get the following error:

Microsoft JET Database Engine (0x80040E14)
In operator without () in query expression ''1. \' In '.

I tried replacing the \' with other characters, and those work fine, however the value in the database is then incorrect. I also tried putting "\" & chr(39) for the last parameter of the replace function, however, this didn't work properly either.