I am having a problem inserting names with apostrophes into the MySQL
database. I am using ASP as my front end with standard SQL statements to
add, edit and delete records. I read the section in the manual on escape
characters and have played around with many different variations trying to
get it to work with absolutely no luck.
The statement I am currently using looks like this:
lname = Replace(Request.Form("lname"),"'","''")
I have tried using the backslash character and several variations of
different numbers of apostrophes.
I would appreciate any help as this is the last problem to be solved before
the database is functional. The rest of the debugging has been completed.
Thank-you in advance,
Loretta
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
