strSQL = "SELECT Position_Name FROM Positon where ( Position_ID IN ("&request.form("checkbox")&")) and ( Position_ID NOT IN (SELECT Position_ID FROM EIM_FuncTitle ))"
...全文
625打赏收藏
这条语句那里错了??谢谢!!!!
strSQL = "SELECT Position_Name FROM Positon where ( Position_ID IN ("&request.form("checkbox")&")) and ( Position_ID NOT IN (SELECT Position_ID FROM EIM_FuncTitle ))"
改为:
strSQL = "SELECT Position_Name FROM Positon where ( Position_ID IN ('"&request.form("checkbox")&"')) and ( Position_ID NOT IN (SELECT Position_ID FROM EIM_FuncTitle ))"