DuringTime=1100
set rs02=server.createobject("adodb.recordset")
sql02="select * from OnLine"
rs02.open sql02,MM_fxcs_STRING,3,2
do while not rs02.eof
if datediff("s",rs02("LastActTime"),now)>=DuringTime then
strSQL = "delete * from OnLine where LastActTime =#"&rs02("LastActTime")&"#"
rs02.execute strSQL
end if
rs02.movenext
loop
rs02.close
set rs02=nothing
那位老大解释一下下面句子的意思啊,我是新手不太明白!
rs02.open sql02,conn,3,2
另外运行提示rs02.execute strSQL出错,那里的错,真是郁闷死了,哎!! :confused:

是的,但是这段代码确实手写的,错那了了??!

数据为ACESS
strSQL = "delete * from OnLine where LastActTime =‘#"&rs02("LastActTime")&"#’"
为MSSQLSERVER
strSQL = "delete * from OnLine where LastActTime =‘"&rs02("LastActTime")&"’"