请问在asp程序里怎么修改一个记录,为什么我的不对?
<%
xgkch=request.querystring("xgkch") '为什么不能取到变量xgkch前面是<form method="post" action="xjxgqd.asp?xgkch="&xgkch> 最后一个xgkch是从前面传来的变量。
kchh=request.form("kchh")
kch=request.form("kchm")
jshgzh=request.form("fshgzh")
teacher=request.form("teacher")
shj=request.form("time")
dd=request.Form("dd")
kkbm=request.Form("kkbm")
xf=request.Form("xf")
xxrsh=request.Form("xxrsh")
shxrsh=request.Form("shxrsh")
set connect=server.createobject("adodb.connection")
connect.open("dsn=xk")
' sql="select * from school"&" where kchm='"&kchmch&"'"
' set rs=connect.execute(sql)
set rs=server.CreateObject("adodb.recordset")
rs.open "school",connect,1,2
rs.movefirst
while not rs.eof
if rs("kchm").value=xgkch then
rs("kchm").value=kch
rs("kchh").value=kchh
rs("jshgzh").value=jshgzh
rs("teacher").value=teacher
rs("time").value=shj
rs("dd").value=dd
rs("kkbm").value=kkbm
rs("xf").value=xf
rs("xxrsh").value=xxrsh
rs("shxrsh").value=shxrsh
end if
rs.movenext
wend
rs.updatebatch
rs.close
set connect=nothing
set rs=nothing
%>