字段有单引号的错误，急

[Eckal]

sql="select Subject1,Subject2 from Journals where JournalName= '"+rs2("JournalName")+"'"
此时JournalName值是Women's International Network News

最后组合的sql就出错了，大家怎么做的？

[hrong]

replace(str, chr(39), chr(34)&"& chr(39) &"&chr(34))

• 打赏
• 举报

回复 赞

[angelheavens]

dd=rs2("JournalName")
dd=replace(dd,"'","""")
sql="select Subject1,Subject2 from Journals where JournalName= '"&dd&"'"

• 打赏
• 举报

回复 赞

[shleo]

试试sql="select Subject1,Subject2 from Journals where JournalName= ""&rs2(""JournalName"")&""

• 打赏
• 举报

回复 赞

[xinxian1366]

可以在存的时候报'存成''
然后显示的时候换回来
当然查的时候也是把'换成''再查

• 打赏
• 举报

回复 赞

[Eckal]

就是把rs2("JournalName")替换一下，楼上的能具体点吗？

• 打赏
• 举报

回复 赞

[swich]

JournalName1=rs2("JournalName")
JournalName1=replace(JournalName1,"'","""")
JournalName=replace(JournalName,"'","""")
sql="select Subject1,Subject2 from Journals where JournalName= '"&JournalName1&"'"

• 打赏
• 举报

回复 赞

[angelheavens]

sorry!hrong(黄蓉 华山论剑)is right!

• 打赏
• 举报

回复 赞

[angelheavens]

sorry!hrong(黄蓉 华山论剑) is right!

• 打赏
• 举报

回复 赞

[swich]

刚才写错了 此时JournalName 为Women's International Network News

JournalName1=rs2("JournalName")
JournalName1=replace(JournalName1,"'","""")
JournalName=replace(JournalName,"'","""")
sql="select Subject1,Subject2 from JournalName where JournalName= '"&JournalName1&"'"

• 打赏
• 举报

回复 赞

[i三千]

sql="select Subject1,Subject2 from Journals where JournalName= '"+replace(rs2("JournalName"),"'","''")+"'"

• 打赏
• 举报

回复 赞

[skyboy0720]

SQL中插入单引号，像当于insert into TABLE (xx) values('')
replace(str,"'","''")
你把输入的字符串中的单引号过滤为两个单引号就可以了！

• 打赏
• 举报

回复 赞

[享受人生-快乐成长]

如果是增加可以用
rs.addnew
rs("column")="Women's International Network News"
rs.update

查询可以用''

• 打赏
• 举报

回复 赞

[Eckal]

谢谢各位

• 打赏
• 举报

回复 赞