|
Subject:
|
Adding line feeds and apostrophes to a database
|
|
Posted By:
|
RiffAff
|
Post Date:
|
1/15/2006 10:53:44 PM
|
I created a database in ACCESS of two fields, one a text field and the other a memo field. I can add to the database all right until I try to add a line feed or an apostrophe.
The code is:
SQL2 = "INSERT INTO tblSignData (nametbl, comtbl) VALUES ('" + myname + "',"
SQL2 = SQL2 + "'" + mycomment + "');"
adoConn.Execute(SQL2)
adoConn.close
Is there another way of writing this code so the LF and apostrohpes are accepted?
Riffaff
|
|
Reply By:
|
lucian
|
Reply Date:
|
1/21/2006 4:40:50 PM
|
did u try using the html version or double quote them?
|
|
