请高手看看,这段代码输入的表单为什么不安能写入数据库(环境没有问题,数据也是正常的,程序可能有问题)
<!--#include file="sys/conn.asp"-->
<%
if request("action")="update" then
id=request("id")
set rs=server.createobject("adodb.recordset")
sqltext="select * from fangwu where id="&id
rs.open sqltext,conn,3,3
fwdz=request.form("fwdz")
jfjc=request.form("jfjc")
jhcz=request.form("jhcz")
jctcz=request.form("jctcz")
jgkmt=request.form("jgkmt")
jsyzx=request.form("jsyzx")
jhxjq=request.form("jhxjq")
if fwdz = "" then fwdz = "未知" end if
rs("fwdz") = fwdz
if jfjc = "" then jfjc = "未知" end if
rs("jfjc") = jfjc
if jhcz = "" then jhcz = "未知" end if
rs("jhcz") = jhcz
if jctcz = "" then jctcz = "未知" end if
rs("jctcz") = jctcz
if jgkmt = "" then jgkmt = "未知" end if
rs("jgkmt") = jgkmt
if jsyzx = "" then jsyzx = "未知" end if
rs("jsyzx") = jsyzx
if jhxjq = "" then jhxjq = "未知" end if
rs("jhxjq") = jhxjq
rs("c_name")=request.form("hotelname")
rs("level")=request.form("hotellevel")
rs("province")=request.form("szSheng")
rs("city")=request.form("szShi")
rs("info")=request.form("hotelinfo")
rs("logurl")=request.form("hotellogurl")
rs("logurl2")=request.form("hotellogurl2")
rs("logurl3")=request.form("hotellogurl3")
rs("logurl4")=request.form("hotellogurl4")
rs("logurl5")=request.form("hotellogurl5")
rs("logurl6")=request.form("hotellogurl6")
rs("logurl7")=request.form("hotellogurl7")
rs("logurl8")=request.form("hotellogurl8")
rs("logurl9")=request.form("hotellogurl9")
rs("logurl10")=request.form("hotellogurl10")
rs("tuijian_id")=request.form("tuijian1")
rs.update
rs.close
conn.close
response.redirect "fwinfo.asp"
else
id=request("id")
set rs=server.createobject("adodb.recordset")
sqltext="select * from fangwu where id="&id
rs.open sqltext,conn,1,1
%>
<html>
<head>
<title>出租房信息编辑</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="system/style.css" type="text/css">
</head>
<body>
<FORM ACTION="editfw.asp" METHOD="POST" NAME="FORM1" onsubmit="return form1_onsubmit()">
<input type=hidden name=action value="update">
<input type=hidden name=id value=<%=request("id")%>>
<div align="center"><br><br><br>
<table width="65%" border=1 align="center" cellPadding=0 cellSpacing=0 bordercolor="#999999" borderColorDark=#ffffff bgcolor="#F9F9F9">
<tbody>
<tr background="Images/topBar_bg.gif">
<td height="30" colspan=2 background="Images/topBar_bg.gif" align="center"><font color="red">出租房信息编辑</font></td>
</tr>
<tr>
<td width=112 height=25 align="right" bgcolor=#EBEBEB >出租房名称：</td>
<td width=396 height=25><input name="hotelname" value="<%=rs("c_name")%>" size="20" maxlength="20">
<font color="#FF0000">*</font></td>
</tr>
<tr>
<td width=112 height=25 align="right" bgcolor=#EBEBEB >出租房地址：</td>
<td width=396 height=25><input name="fwdz" id="fwdz" value="<%=rs("fwdz")%>" size="20" maxlength="20">
<font color="#FF0000">*</font></td>
</tr>
<tr>
<td width=112 height=25 align="right" bgcolor=#EBEBEB >距飞机场：</td>
<td width=396 height=25><input name="jfjc" id="jfjc" value="<%=rs("jfjc")%>" size="20" maxlength="20">
<font color="#FF0000">*</font></td>
</tr>
<tr>
<td width=112 height=25 align="right" bgcolor=#EBEBEB >距火车站：</td>
<td width=396 height=25><input name="jhcz" id="jhcz" value="<%=rs("jhcz")%>" size="20" maxlength="20">
<font color="#FF0000">*</font></td>
</tr>
<tr>
<td width=112 height=25 align="right" bgcolor=#EBEBEB >距长途车站：</td>
<td width=396 height=25><input name="jctcz" id="jctcz" value="<%=rs("jctcz")%>" size="20" maxlength="20">
<font color="#FF0000">*</font></td>
</tr>
<tr>
<td width=112 height=25 align="right" bgcolor=#EBEBEB >距港口码头：</td>
<td width=396 height=25><input name="jgkmt" id="jgkmt" value="<%=rs("jgkmt")%>" size="20" maxlength="20">
<font color="#FF0000">*</font></td>
</tr>
<tr>
<td width=112 height=25 align="right" bgcolor=#EBEBEB >距商业中心：</td>
<td width=396 height=25><input name="jsyzx" id="jsyzx" value="<%=rs("jsyzx")%>" size="20" maxlength="20">
<font color="#FF0000">*</font></td>
</tr>
<tr>
<td width=112 height=25 align="right" bgcolor=#EBEBEB >距核心景区：</td>
<td width=396 height=25><input name="jhxjq" id="jhxjq" value="<%=rs("jhxjq")%>" size="20" maxlength="20">
<font color="#FF0000">*</font></td>
</tr>
<tr>
<td height="35" colspan=2 background="Images/topBar_bg.gif">
<p align="center">
<input type=SUBMIT value=" 修 改 " class="medium" onClick="javascript:return checksignup()" name="signup_submit">
<input type=RESET value="重 填" class="medium" name="signup_reset">
<input name="button" type="button" class="main" onClick="javascript:window.history.go(-1)" value="返回" size="3">
</td>
</tr>
</table>
</div>
<p align="center">
</form>
</body>
</html>
<%
rs.close
conn.close
end if
%>
