sql="select Subject1,Subject2 from Journals where JournalName= '"+rs2("JournalName")+"'"
此时JournalName值是Women's International Network News
最后组合的sql就出错了,大家怎么做的?
...全文
5113打赏收藏
字段有单引号的错误,急
sql="select Subject1,Subject2 from Journals where JournalName= '"+rs2("JournalName")+"'" 此时JournalName值是Women's International Network News 最后组合的sql就出错了,大家怎么做的?
刚才写错了 此时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 Journals where JournalName= '"&JournalName1&"'"