dim cxxmmcc,cxxmmce,jsfw,jsnx,cxd,cxkxjsyd,gjcc,gjce,xmcl,lwzl,xmzcy,ckwx,xgyjcxy,xgyj,wid
dim rs,sql
'------------------------------------------------------开始接收参数15个--------------
cxxmmcc = trim(request.Form("cxxmmcc"))
cxxmmce = trim(request.Form("cxxmmce"))
jsfw
= request.Form("jsfw")
jsnx
= request.Form("jsnx")
cxd
= trim(request.Form("cxd"))
cxkxjsyd= trim(request.Form("cxkxjsyd"))
gjcc
= trim(request.Form("gjcc"))
gjce
= trim(request.Form("gjce"))
'xmcl
= trim(request.Form("xmcl"))
lwzl
= trim(request.Form("lwzl"))
xmzcy
= trim(request.Form("xmzcy"))
ckwx
= trim(request.Form("ckwx"))
xgyjcxy= trim(request.Form("xgyjcxy"))
xgyj
=trim(request.Form("xgyj"))
wid
=request.Form("wid")
'------------------------------------------------------------接收参数完成----------------------
sql = "select * from wts where id like "&wid
'response.Write(xgyj)
'response.Write(xgyjcxy)
'response.Write(cxxmmcc)
'response.Write(sql)
'response.End()
set rs=server.CreateObject("ADODB.recordset")
rs.open sql,conn,1,3
on error resume next
'-----------修改委托书表数据--------------
rs("wts_cxxmmcc") = cxxmmcc
rs("wts_cxxmmce") = cxxmmce
rs("wts_jsfw")
= jsfw
rs("wts_jsnx")
= jsnx
rs("wts_cxd")
= cxd
rs("wts_cxkxjsyd")= cxkxjsyd
rs("wts_gjcc")
= gjcc
rs("wts_gjce")
= gjce
'rs("wts_xmcl")
= xmcl
rs("wts_lwzl")
= lwzl
rs("wts_xmzcy")
= xmzcy
-----》这个地方写入有问题
rs("wts_ckwx")
= ckwx
------》这个地方写入有问题
rs("wts_xgyj")
= xgyj
------》这个地方写入有问题
rs("wts_xgyjcxy") = xgyjcxy
rs("wts_cxzt")
= "查新员修改"
rs.update
'--------------------------------------
if err <> 0 then
response.Write("<br>")
response.Write("出错号:")
response.Write(Err.number )
response.Write("<br>")
response.Write("出错原因:")
response.Write(Err.Source )
response.Write("<br>")
response.Write("错误描述:")
response.Write(Err.Description)
response.End()
else
%>
<script language="javascript">
alert ("委托书修改成功!");
window.navigate("showwts.asp");
</script>
<%
end if
'---------------------------------
rs.close
set rs=nothing
conn.close
set conn=nothing
########################################################
########################################################
以上标出来的有问题的地方使用ntext类型的数据时会导致iis进程死掉数据库写不了数据,也不报错,但是改成varchar(8000)后就没问题了,请问大侠们是什么问题??