asp-classic - 删除查询无法从表单中获取值

Question

我想从预订表中删除预订记录，但删除查询无法从表单中获取值

<form method="post" action="">
Enter booking Id<input type="text" id='bookid' name='bookid' required>
<button class="button1" id="bcancel" name="bcancel" value="cancel">Cancel 
Booking</button>
</form>
<%
set conn=Server.CreateObject("ADODB.Connection")    
conn.Provider="Microsoft.Jet.OLEDB.4.0"    
conn.Open(Server.Mappath("Aurangabad1.mdb"))
set rs = Server.CreateObject("ADODB.recordset")

dim am,del
del="cancel"
am=request("bcancel")
if(am=del) then
sql="delete from booking where bid= '"& Request.form("bookid") & "'"
on error resume next
conn.Execute sql,info
if err<>0 then
Response.Write("<center>Booking Not Canceled..!</center>")
else
Response.Write("<center><h2>" & info & " Booking Canceled</h2></center>")
end if
end if
conn.close
%>

标签： asp-classic