替换问题!?

greatyollow 发布于 2007-10-24 10:32， 407 次点击

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

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

5 回复

madpbpl2007-10-24 13:04

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

greatyollow2007-10-24 13:17

没动静

greatyollow2007-10-24 14:05

greatyollow2007-10-24 14:11

greatyollow2007-10-24 14:46

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

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