| Welcome to WebmasterWorld Guest from 188.8.131.52 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|Help with SQL statement!|
apostrophes and quotation marks
| 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?
| 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.
| 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,"'","''")
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved