sqlStr=sqlStr & " where BooKID=" & request.form(inputstr)
sqlStr变量重复连接了原值,导致SQL语句出错
这样写
sqlStr="select * from mytable where BooKID=" & request.form(inputstr)
就对了
sqlStr变量重复连接了原值,导致SQL语句出错
这样写
sqlStr="select * from mytable where BooKID=" & request.form(inputstr)
就对了
这句前加一句:if rs.state=adstateopen then rs.close'打开之前先关闭