28,409
社区成员
发帖
与我相关
我的任务
分享字段有单引号的错误，急
sql="select Subject1,Subject2 from Journals where JournalName= '"+rs2("JournalName")+"'"
此时JournalName值是Women's International Network News
最后组合的sql就出错了，大家怎么做的？
此时JournalName值是Women's International Network News
最后组合的sql就出错了，大家怎么做的？
...全文
请发表友善的回复…
发表回复
Eckal 2003-12-12
- 打赏
- 举报
谢谢各位
享受人生-快乐成长 2003-12-12
- 打赏
- 举报
如果是增加可以用
rs.addnew
rs("column")="Women's International Network News"
rs.update
查询可以用''
rs.addnew
rs("column")="Women's International Network News"
rs.update
查询可以用''
skyboy0720 2003-12-12
- 打赏
- 举报
SQL中插入单引号，像当于insert into TABLE (xx) values('')
replace(str,"'","''")
你把输入的字符串中的单引号过滤为两个单引号就可以了！
replace(str,"'","''")
你把输入的字符串中的单引号过滤为两个单引号就可以了！
i三千 2003-12-12
- 打赏
- 举报
sql="select Subject1,Subject2 from Journals where JournalName= '"+replace(rs2("JournalName"),"'","''")+"'"
swich 2003-12-12
- 打赏
- 举报
刚才写错了 此时JournalName 为Women's International Network News
JournalName1=rs2("JournalName")
JournalName1=replace(JournalName1,"'","""")
JournalName=replace(JournalName,"'","""")
sql="select Subject1,Subject2 from JournalName where JournalName= '"&JournalName1&"'"
JournalName1=rs2("JournalName")
JournalName1=replace(JournalName1,"'","""")
JournalName=replace(JournalName,"'","""")
sql="select Subject1,Subject2 from JournalName where JournalName= '"&JournalName1&"'"
angelheavens 2003-12-12
- 打赏
- 举报
sorry!hrong(黄蓉 华山论剑) is right!
angelheavens 2003-12-12
- 打赏
- 举报
sorry!hrong(黄蓉 华山论剑)is right!
swich 2003-12-12
- 打赏
- 举报
JournalName1=rs2("JournalName")
JournalName1=replace(JournalName1,"'","""")
JournalName=replace(JournalName,"'","""")
sql="select Subject1,Subject2 from Journals where JournalName= '"&JournalName1&"'"
JournalName1=replace(JournalName1,"'","""")
JournalName=replace(JournalName,"'","""")
sql="select Subject1,Subject2 from Journals where JournalName= '"&JournalName1&"'"
Eckal 2003-12-12
- 打赏
- 举报
就是把rs2("JournalName")替换一下，楼上的能具体点吗？
xinxian1366 2003-12-12
- 打赏
- 举报
可以在存的时候报'存成''
然后显示的时候换回来
当然查的时候也是把'换成''再查
然后显示的时候换回来
当然查的时候也是把'换成''再查
shleo 2003-12-12
- 打赏
- 举报
试试sql="select Subject1,Subject2 from Journals where JournalName= ""&rs2(""JournalName"")&""
angelheavens 2003-12-12
- 打赏
- 举报
dd=rs2("JournalName")
dd=replace(dd,"'","""")
sql="select Subject1,Subject2 from Journals where JournalName= '"&dd&"'"
dd=replace(dd,"'","""")
sql="select Subject1,Subject2 from Journals where JournalName= '"&dd&"'"
hrong 2003-12-12
- 打赏
- 举报
replace(str, chr(39), chr(34)&"& chr(39) &"&chr(34))
