帮我看看这ASP代码有没有错

Set rs=conn.execute("Select PriceOrigin From buyok_produc")
do while not rs.eof
Conn.Execute("Update buyok_produc Set PriceOrigin="&rs("PriceOrigin")*6)
rs.movenext
loop
rs.close
set rs=nothing

把PriceOrigin的值乘于6,再写进数据库,批量的
PriceOrigin 字段是货币类型

还没解决

Set rs=conn.execute("Select PriceOrigin From buyok_produc")
do while not rs.eof
rs("PriceOrigin")=6*rs("PriceOrigin")
rs.update
rs.movenext
loop
rs.close
set rs=nothing

你更新总的有个条件吧
也不知道你库里的编号字段是什么
我况且用id代替你的编号字段来表示

Set rs=conn.execute("Select PriceOrigin From buyok_produc")
do while not rs.eof
Conn.Execute("Update buyok_produc Set PriceOrigin="&rs("PriceOrigin")*6" where id="&rs("id")&"")
rs.movenext
loop
rs.close
set rs=nothing

一看就是个逍遥游网店系统

Conn.Execute("Update buyok_produc Set PriceOrigin = PriceOrigin * 6")

Set rs=conn.execute("Select PriceOrigin From buyok_produc")
do until rs.eof
Conn.Execute("Update buyok_produc Set PriceOrigin="&rs("PriceOrigin")*6 &" WHERE ID="& rs("ID"))
rs.movenext