<!--#include file="../inc/conn.asp"-->
<!--#include file="checkpwd.asp"-->
<!--#include file="../inc/title.inc"-->
<%
bianh=request.Form("hiddenField")
roomlei=request.Form("roomlei")
roompice=request.Form("roompice")
totnum=request.Form("totnum")
jianjie=request.Form("jianjie")
'sql="update  book set chk=true where zhengjianh='"&zjhao&"'"'和NO一樣這個字段不能用check否則會查詢不出來
sql="update [room] set roomnam='"&roomlei&"' ,descrip='"&jianjie&"',pric='"&roompice&"',totnum='"&totnum&"' where id="&bianh
'response.Write(sql)
conn.execute(sql)
conn.close
Response.Write("<script>alert(""修改成功"");location.href=""room.asp"";</script>")
%>