<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../../login/check_power.asp"-->
<%
table_name="housestate"
if check_power("參數設置")=0 then
  response.redirect("/login/check_false.asp")
else%><%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = "dsn=hotel;"
Recordset1.Source = "SELECT *  FROM db_"&table_name&" where id="&request.form("id")
Recordset1.CursorType = 3
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open
Recordset1_numRows = 0
%> <%
recordset1("name").value=request.form("name")
if request.form("memo")<>"" then
  Recordset1("memo").value=request.form("memo")
else
  Recordset1("memo").value=""
end if
Recordset1.update
Recordset1.close
response.redirect(table_name&"_show.asp")
%>
<%end if%>