allow users to enter single quotes in text box
Posted on 2006-04-15
I would like to allow people to use single quotes while writing something in a text box that will be updated in a DB.
Currently if people try to type for example: "Friend's" there is an error.
Can someone help me modify my code below to allow me to do this?
sql = "UPDATE tblData SET back_colour = '" & request("bcolor") & "', font_size = '" & request("fsize") & "', main_text = '" & request("mtext") & "', page_name = '" & request("pname") & "', modified=true WHERE email ='" & session("usersession") & "'"
I need it to be enabled for the whole sql statement and not just one DB field.