哪位朋友帮忙看一眼?替换问题!

对指定的ID记录,替换bei_zhu字段,

sub replCate()
conn.execute("UPDATE news SET bei_zhu=replace(bei_zhu,'未结算','已结算') from client where id in ("&Request.Form("selBigClass")&")")
response.Write "<script language=javascript>alert('更改结算完成！');</script>"
response.write "<meta http-equiv=""refresh"" content=""0;url=client.asp"">"
response.end
end sub

楼主的意思是不是bei_zhu是未结算，打算替换成已结算？
还有具体有什么报错信息吗？

没动静

我已成功解决!谢谢各位朋友帮助!

sub replCate()
conn.execute("update client set bei_zhu='已结算' where id in ("&Request.Form("selBigClass")&")")
response.Write "<script language=javascript>alert('更改结算完成！');</script>"
response.write "<meta http-equiv=""refresh"" content=""0;url=client.asp"">"
response.end
end sub