.asp page not updating database correctly

[chridd]

I have been practicing writing a form to a access 2003 database. If the user places an (') (ie. dave's house) in a text box and submit the form, when I go to the database the record cuts everything off past the (')(ie.dave). I have tried everything I know to figure this out. I am not sure if it is the .asp not sending all the data bast the (') to the access database or if the access database is rejecting everything after the (')..

Help!!!

 

[Sheco]

The problem is not the ASP... its the SQL.

The single quote character is a SQL delimitter.

The easy fix is to replace it with another character.. I like the ` character that is just to the left of the 1 on my keyboard.

myString = Replace(myString, "'", "`")

 

[SecondToNone]

Or Try this:

Replace(mystring,"'","''")

-SecondToNone

 

[chridd]

Thank you! That will do.