Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Help with SQL statement!

apostrophes and quotation marks

9:16 pm on Oct 17, 2005 (gmt 0)

10+ Year Member

i have a string variable(txtmessage)
txtmessage has both apostrophes and quotation marks

my insert statement looks like this:


fails every time. i must be able to allow both quotes and apost... but how?

using access

4:07 am on Oct 18, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member

Try using square bracket delimiters:

if that doesn't work search MS or online re: microsoft access delimiters or similar.

4:44 am on Oct 18, 2005 (gmt 0)

10+ Year Member

Try replacing each apostrophe in the string variable with two consecutive apostrophes.

In vbscript I think the function is: txtmessage=replace(txtmessage,"'","''")


Featured Threads

Hot Threads This Week

Hot Threads This Month