| Help with SQL statement!
apostrophes and quotation marks |
jefferson
msg:1578926 | 9:16 pm on Oct 17, 2005 (gmt 0) |
i have a string variable(txtmessage)
txtmessage has both apostrophes and quotation marks my insert statement looks like this: strSQL = "INSERT INTO MYTABLE (MESSAGE) VALUES (" & TXTAMESSAGE & ")" fails every time. i must be able to allow both quotes and apost... but how? using access
|
iamlost
msg:1578927 | 4:07 am on Oct 18, 2005 (gmt 0) |
Try using square bracket delimiters:
[" & TXTAMESSAGE & "] if that doesn't work search MS or online re: microsoft access delimiters or similar.
|
wsp9
msg:1578928 | 4:44 am on Oct 18, 2005 (gmt 0) |
Try replacing each apostrophe in the string variable with two consecutive apostrophes. In vbscript I think the function is: txtmessage=replace(txtmessage,"'","''")
|
|
|
