asp 修改资料
<%
zhengjianhaoma=Request.Form("zhengjianhaoma")
mingchengnew=Request.Form("mingchengnew")
kaihubumennew=Request.Form("kaihubumennew")
if zhengjianhaoma <> "" then
set rs1 = Server.CreateObject("ADODB.recordSet")
sql1 = "select * from tab1 where 证件号码='"&zhengjianhaoma&"' "
rs1.open sql1,conn,1,3
if not rs1.eof then
rs1("客户名称")=mingchengnew
rs1("开户部门")=kaihubumennew
rs1.update
response.Write("修改成功")
else
response.Write("记录不存在")
end if
rs1.close
set rs1=nothing
end if%>这样修改的话,客户名称和开户部门都修改了,有时我只想修改开户部门,客户名称不填写,那样客户名称也跟着修改,变成空内容了,怎么编写客户名称里面的内容不变!请高手写出代码,谢谢!
------解决方案--------------------在HTML表单中的value属性里加上RS对应记录即可~
------解决方案--------------------if not rs1.eof then
rs1("客户名称")=mingchengnew
rs1("开户部门")=kaihubumennew
rs1.update
这里加上判断,
比如:
if not rs1.eof then
if mingchengnew <>'' then
rs1("客户名称")=mingchengnew
end if
if kaihubumennew <>'' then
rs1("开户部门")=kaihubumennew
end if
rs1.update