主题:更新一条记录怎么变添加一条记录呢!
为什么会变成添加一条记录进去呢!!
<!--#include file="Connections/dd.asp" -->
<%
'/*提交修改*/
dim id,action
id=request("MM_recordId")
action=request("action")
select case action
case "eitdjian"
set rs=server.CreateObject("adodb.recordset")
strsql="select * from [driver_down] where id="&id
rs.Open strsql,conn,1,3
'response.Write(strsql)
' response.end()
rs.AddNew
rs("driver_no")=trim(request.form("driver_no"))
rs("driver_name")=trim(request.form("driver_name"))
rs("driver_sys")=trim(request.form("driver_sys"))
rs("driver_data")=trim(request.form("driver_data"))
rs("driver_size")=trim(request.form("driver_size"))
rs("driver_down")=trim(request.form("driver_down"))
rs("driver_lei")=trim(request.form("driver_lei"))
rs("driver_enname")=trim(request.form("driver_enname"))
rs("driver_twname")=trim(request.form("driver_twname"))
rs.update
rs.Close
set rs=nothing
conn.close
set conn=nothing
response.Write "<script language=javascript>alert('修改驱动下载成功!');history.go(-2);</script>"
response.End
end select
%>
<!--#include file="Connections/dd.asp" -->
<%
'/*提交修改*/
dim id,action
id=request("MM_recordId")
action=request("action")
select case action
case "eitdjian"
set rs=server.CreateObject("adodb.recordset")
strsql="select * from [driver_down] where id="&id
rs.Open strsql,conn,1,3
'response.Write(strsql)
' response.end()
rs.AddNew
rs("driver_no")=trim(request.form("driver_no"))
rs("driver_name")=trim(request.form("driver_name"))
rs("driver_sys")=trim(request.form("driver_sys"))
rs("driver_data")=trim(request.form("driver_data"))
rs("driver_size")=trim(request.form("driver_size"))
rs("driver_down")=trim(request.form("driver_down"))
rs("driver_lei")=trim(request.form("driver_lei"))
rs("driver_enname")=trim(request.form("driver_enname"))
rs("driver_twname")=trim(request.form("driver_twname"))
rs.update
rs.Close
set rs=nothing
conn.close
set conn=nothing
response.Write "<script language=javascript>alert('修改驱动下载成功!');history.go(-2);</script>"
response.End
end select
%>