说我语法错误~
sql="SELECT * FROM jxkh_jy WHERE jh='" & Replace(username,"'","''") & "' and password='" & Replace(password,"'","''") & "' and zwdh='3602' or zwdh='3601' zwdh='3501' zwdh='3103' zwdh='3104' zwdh='3205'"
...全文
584打赏收藏
小问题~快来帮我看一下下~
说我语法错误~ sql="SELECT * FROM jxkh_jy WHERE jh='" & Replace(username,"'","''") & "' and password='" & Replace(password,"'","''") & "' and zwdh='3602' or zwdh='3601' zwdh='3501' zwdh='3103' zwdh='3104' zwdh='3205'"
sql="SELECT * FROM jxkh_jy WHERE jh='" & Replace(username,"'","''") & "' and password='" & Replace(password,"'","''") & "' and zwdh in ('3601', '3501' ,'3103' ,'3104' ,'3205','3602')"
是这个意思么?
sql="SELECT * FROM jxkh_jy WHERE jh='" & Replace(username,"'","''") & "' and password='" & Replace(password,"'","''") & "' and (zwdh='3602' or zwdh='3601' zwdh='3501' zwdh='3103' zwdh='3104' zwdh='3205') "