求助关于存储和更新!各位大侠请进来!
<%
if request("action")="add" then
name=request.form("name")
sex=request.form("sex")
age=request.form("age")
nation=request.form("nation")
government=request.form("government")
diqu=request.form("diqu")
address=request.form("address")
xuexiao=request.form("xuexiao")
xueli=request.form("xueli")
specialty=request.form("specialty")
age2=request.form("age2")
chinese=request.form("chinese")
pay=request.form("pay")
manner=request.form("manner")
traffic=request.form("traffic")
subject=request.form("subject")
experience=request.form("subject")
introduce=request.form("introduce")
tel=request.Form("tel")
mobile=request.form("mobile")
email=request.Form("email")
Contract2=request.Form("Contract2")
state=request.form("state")
pub=request.form("pub")
retain=request.form("retain")
count=request.form("count")
adddate=now()
end if
set rs=server.createobject("adodb.recordset")
sql="select * from teacher"
rs.open sql,conn,1,3
if not(rs.bof and rs.eof) then
rs.addnew
rs("num")=200000+rs("id")
rs("name")=name
rs("sex")=sex
rs("age")=age
rs("government")=government
rs("nation")=nation
rs("diqu")=diqu
rs("address")=address
rs("xuexiao")=xuexiao
rs("xueli")=xueli
rs("specialty")=specialty
rs("age2")=age2
rs("chinese")=chinese
rs("pay")=pay
rs("manner")=manner
rs("subject")=subject
rs("traffic")=traffic
rs("experience")=experience
rs("introduce")=introduce
rs("tel")=tel
rs("mobile")=mobile
rs("Contract2")=Contract2
rs("email")=email
rs("state")=state
rs("pub")=pub
rs("retain")=retain
rs("count")=count
rs("adddate")=adddate
rs.update
response.write ""
rs.close
set rs=nothing
response.end
end if
%>
<%
if request("action")="edit" then
';dim id
id=request.QueryString("id")
name=request.form("name")
sex=request.form("sex")
age=request.form("age")
nation=request.form("nation")
government=request.form("government")
diqu=request.form("diqu")
address=request.form("address")
xuexiao=request.form("xuexiao")
xueli=request.form("xueli")
specialty=request.form("specialty")
age2=request.form("age2")
chinese=request.form("chinese")
pay=request.form("pay")
manner=request.form("manner")
traffic=request.form("traffic")
subject=request.form("subject")
experience=request.form("subject")
introduce=request.form("introduce")
tel=request.Form("tel")
mobile=request.form("mobile")
email=request.Form("email")
Contract2=request.Form("Contract2")
state=request.form("state")
pub=request.form("pub")
retain=request.form("retain")
count=request.form("count")
adddate=now()
end if
set rs=server.createobject("adodb.recordset")
sql="select * from teacher where id="&id
rs.open sql,conn,1,3
if not(rs.bof and rs.eof) then
rs("num")=200000+rs("id")
rs("name")=name
rs("sex")=sex
rs("age")=age
rs("government")=government
rs("nation")=nation
rs("diqu")=diqu
rs("address")=address
rs("xuexiao")=xuexiao
rs("xueli")=xueli
rs("specialty")=specialty
rs("age2")=age2
rs("chinese")=chinese
rs("pay")=pay
rs("manner")=manner
rs("subject")=subject
rs("traffic")=traffic
rs("experience")=experience
rs("introduce")=introduce
rs("tel")=tel
rs("mobile")=mobile
rs("Contract2")=Contract2
rs("email")=email
rs("state")=state
rs("pub")=pub
rs("retain")=retain
rs("count")=count
rs("adddate")=now()
rs.update
end if
response.write ""
rs.close
set rs=nothing
response.end
%>
当执行action=save时可以存储信息,当执行action=edit时信息更新不了
大家帮我看一下是怎么回事啊
我QQ是187225796