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

对指定的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

没动静

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

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