homepage Welcome to WebmasterWorld Guest from 54.161.192.61
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Help with SQL statement!
apostrophes and quotation marks
jefferson

5+ Year Member



 
Msg#: 99 posted 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

WebmasterWorld Senior Member 10+ Year Member



 
Msg#: 99 posted 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

5+ Year Member



 
Msg#: 99 posted 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,"'","''")

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved