<% if request.querystring("action")="edit" then
Id =trim(request.form("id"))
set rs=server.createobject("adodb.recordset")
sql="select * from buy where id=" & Id
rs.open sql,conn,3,3
'更新产品信息到数据库
rs("xxlx")=trim(request.form("xxlx"))
rs("gybt")=trim(request.form("gybt"))
rs("yxq")=trim(request.form("yxq"))
rs("szd")=trim(request.form("szd"))
rs("gs")=trim(request.form("gs"))
rs("lxr")=trim(request.form("lxr"))
rs("dz")=trim(request.form("dz"))
rs("dh")=trim(request.form("dh"))
rs("cz")=trim(request.form("cz"))
rs("gszy")=trim(request.form("gszy"))
rs("xxxx")=trim(request.form("xxxx")) 'xxxx文本区域字段,上面的是文本字段

rs.update
response.Write "<script language=javascript>alert('修改供求信息成功！');window.location.href='del_buy.asp';</script>"
rs.close
set rs=nothing
conn.close
set conn=nothing
end if
%>
出现的问题是在更新的时候文本区域字段无法更新,但是文本字段却可以.,求教了

不好意思该是求助的给发成为原创了....

<% if request.querystring("action")="edit" then
Id =trim(request.form("id"))
set rs=server.createobject("adodb.recordset")
sql="select * from jobs where id=" & Id
rs.open sql,conn,3,3
'更新产品信息到数据库
rs("zwmc")=trim(request.form("zwmc"))
rs("xbyq")=trim(request.form("xbyq"))
rs("zprs")=trim(request.form("zprs"))
rs("gzjy")=trim(request.form("gzjy"))
rs("yxhw")=trim(request.form("yxhw"))
rs("gzdd")=trim(request.form("gzdd"))
rs("yysp")=trim(request.form("yysp"))
rs("xlyq")=trim(request.form("xlyq"))
rs("zwms")=trim(request.form("zwms"))
rs("fbrq")=trim(request.form("fbrq"))
rs("yxq")=trim(request.form("yxq"))

sqltext="UPDATE jobs SET zwmc='"&zwmc&"',xbyq='"&xbyq&"',zprs='"&zprs&"',gzjy='"&gzjy&"',yxhw='"&yxhw&"',
gzdd='"&gzdd&"',yysp='"&yysp&"' ,xlyq='"&xlyq&"',zwms='"&zwms&"' ,fbrq='"&fbrq&"',yxq='"&yxq&"'
WHERE id="&cint(id)
conn.execute sqltext

response.Write "<script language=javascript>alert('修改产品成功！');window.location.href='del_job.asp';</script>"
rs.close
set rs=nothing
conn.close
set conn=nothing
end if
%>
这样写好象也不行

[此贴子已经被作者于2006-10-30 18:04:59编辑过]