if Request.Form("hid")"" then bookid=request.form("book_id")if bookid=null or bookid="" then bookid="0"'注意是字符类型的sql="update bookinfo set base='是' where bookid="&bookid conn.execute(sql) sql="delete * from borrowinfo where bookid="&bookid conn.execute(sql) response.redirect"return.asp" end if
在“sql="delete * from borrowinfo where bookid="&bookid&"" ”前面加“if bookid=null or bookid="" then bookid=0”:如下if Request.Form("hid")"" then bookid=request.form("book_id") sql="update bookinfo set base='是' where bookid="&bookid&"" conn.execute(sql) if bookid=null or bookid="" then bookid=0 sql="delete * from borrowinfo where bookid="&bookid&"" conn.execute(sql) response.redirect"return.asp" end if