一个关于数据更新的问题
id在数据库中是表的标识列,类型为int,不知代码有什么错误?
<%@LANGUAGE="VBSCRIPT" CODEPAGE="CP_ACP"%>
<!-- #include file="conn.asp" -->
<%
id=trim(request.querystring("id"))
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%
sql="select * from servenet where id='"&id&"'"
rs.open sql,conn,1,3
rs("mode")=session("mode")
rs("province")=trim(request.form("province"))
rs("city")=trim(request.Form("city"))
rs("place")=trim(request.Form("place"))
rs("linkman")=trim(request.Form("linkman"))
rs("phone")=trim(request.Form("phone"))
rs("address")=trim(request.Form("address"))
rs("code")=trim(request.Form("code"))
rs.update
response.Write("<center><font color=#ff0000>数据修改成功!</font></center><br><br>")
response.write("<center><a href="javascript:history.go(-1)">请返回</a></center>")
%>
</body>
</html>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>