Question

语法错误 (操作符丢失) 在查询表达式 'bookid=' 中。

1.Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'bookid=' 中。
/tsgl/return.asp, 第 110 行

if Request.Form("hid")<>"" then
bookid=request.form("book_id")
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

bookid是 数字类型并为空值时候就出现这种情况，用哪中方法不让程序出现这种情况
请高手指点

Answer 1

在“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

Answer 2

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