发新话题
打印

求助关于存储和更新!各位大侠请进来!

求助关于存储和更新!各位大侠请进来!

<% 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

TOP

求助关于存储和更新!各位大侠请进来!

从语句上看没有什么问题??
你把保存更新后,出现的错误信息发出来看看才明白!

TOP

发新话题