注册 登录
编程论坛 ASP技术论坛

在线统计引用问题

kgdipbyve 发布于 2008-11-14 16:34, 724 次点击
<%
sessionID = session.SessionID
timeout =1
aaa = dateadd("n", -timeout, now())
connCount.Execute ("delete * from count where postdate < #" & aaa & "#")
sql0 = "select sess from count where sess='" & sessionID & "'"
set rscheck = connCount.Execute (sql0)
if rscheck.eof then
sql = "insert into count (sess,postdate) values('" & sessionID & "', '" & now() & "')"
connCount.Execute (sql)
end if
rscheck.close
set rscheck = nothing

sql2 = "select count(sess) from count"
set rs = connCount.Execute (sql2)
count = rs(0)
rs.close
set rs = nothing


sql3 = "select * from count"
set rspredel = connCount.Execute (sql3)
do until rspredel.eof
xxx=DateDiff("n", rspredel("postdate"), Now())
if xxx > timeout then
count = count-1
end if
rspredel.movenext
loop
rspredel.close
set rspredel = nothing

connCount.Close
set connCount = nothing

if count = 0 then
count = 1
end if
%>
这段代码能运行起来,但是把这代码嵌套在别的面出会很慢.提示
Active Server Pages, ASP 0113 (0x80004005)


[[it] 本帖最后由 kgdipbyve 于 2008-11-14 16:48 编辑 [/it]]
2 回复
#2
yms1232008-11-15 13:25
[bo][un]kgdipbyve[/un] 在 2008-11-14 16:34 的发言:[/bo]
<%
sessionID = session.SessionID
timeout =1
aaa = dateadd("n", -timeout, now())
connCount.Execute ("delete * from count where postdate < #" & aaa & "#")
'这里的时间好像不能直接比较大小吧?
sql0 = "select sess from count where sess='" & sessionID & "'"
set rscheck = connCount.Execute (sql0)
if rscheck.eof then
   sql = "insert into count (sess,postdate) values('" & sessionID & "', '" & now() & "')"
   connCount.Execute (sql)
end if
rscheck.close
set rscheck = nothing

sql2 = "select count(sess) from count"
set rs = connCount.Execute (sql2)
count = rs(0)
rs.close
set rs = nothing


sql3 = "select * from count"
set rspredel = connCount.Execute (sql3)
do until rspredel.eof
   xxx=DateDiff("n", rspredel("postdate"), Now())
   if xxx > timeout then
      count = count-1
   end if
   rspredel.movenext
loop
rspredel.close
set rspredel = nothing

connCount.Close
set connCount = nothing

if count = 0 then
   count = 1
end if
%>
%>
这段代码 ...

另外把错误信息贴完整
#3
kgdipbyve2008-11-15 14:30
找到错了。connCount这个错了。是CONN,
谢了斑竹!
现在还有个问题就是,我要在首页里显示别的页面下的在线人数的
这个应该怎么写?

[[it] 本帖最后由 kgdipbyve 于 2008-11-15 14:36 编辑 [/it]]
1