exec="select * from YC_pic "
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,3


i=0
b=0
if not rs.eof then
do while not rs.eof
if rs("jstime")<date() then
rs("huishou")="1"
i=i+1
else
rs("huishou")="0"
b=b+1
end if
rs.update

rs.movenext
loop
end if


'rs.close
'set rs=nothing
'conn.close
'set conn=nothing