Hi, I am new here, I am trying to insert a comment about a particular item, and the description, if it contains an apostorphe ' or quotes " it plays hanky panky with the insert statement, how can I have my insert statement insert ALL of the charachters, including apostorphies, etc...
here's the code in question, and i get an error when i try to insert anything with an apostrophe.
sql = "INSERT into project_tbl (project_name, description, creation_date) VALUES ('" & projectname & "','" & projectdescription & "','" & createdate & "')"
In this example I have the database trying to insert when "projectdescription = description's" . But if I enter descriptions without the apostrophe, it works...is there some sort of tag, or delimiting mark I can put on the statment telling it to accept all values verbatum, and not try to parse them? Thank you!
here's the code in question, and i get an error when i try to insert anything with an apostrophe.
sql = "INSERT into project_tbl (project_name, description, creation_date) VALUES ('" & projectname & "','" & projectdescription & "','" & createdate & "')"
In this example I have the database trying to insert when "projectdescription = description's" . But if I enter descriptions without the apostrophe, it works...is there some sort of tag, or delimiting mark I can put on the statment telling it to accept all values verbatum, and not try to parse them? Thank you!