var t = new Date;
var sday = new Date;
var dday = new Date
sday = new Date(t.getYear(),t.getMonth()-1,1)
stime=sday.getTime()
dday = new Date(t.getYear(),t.getMonth(),1)
dtime=dday.getTime()
sday.setTime(stime)
dday.setTime(dtime)
stime=Math.round(stime/1000)
dtime=Math.round(dtime/1000)
var rs1 = Server.CreateObject("ADODB.RecordSet")
var sqlStr1 = "select top 10 sender,sum(points)as c from jl where sendtime >= '"+stime+"' GROUP BY sender order by c desc"
ASP页面老是报错
调试了下 rs1 以上的代码,控制台没有没有报错呀。
目测有点问题的是 sqlStr1 的 as 前面没有空格,new Date() 后面需要括号。此外这个 stime 竟然是负数,应该是 new Date(t.getYear(),t.getMonth(),1) 这个用法错误导致的: