<%
'时代互联网程序
set rs=server.createObject("adodb.recordset")
sql="select * from news"
rs.open sql,conn,1,3
do while not rs.eof
rs("paiming")=0
rs.delete
rs.movenext
loop
rs.close
set rs=nothing
也可以:conn.Execute "Delete From news"
'修改数据
set rs=server.createObject("adodb.recordset")
sql="select * from news"
rs.open sql,conn,1,3
do while not rs.eof
rs("paiming")=0
rs.update
rs.movenext
loop
rs.close
set rs=nothing
%>