神马品牌网我的世界13号唱片视频:ASP本周热门怎么写，本周更新怎么写啊，代码～！
来源：百度文库 编辑：神马品牌网 时间：2024/05/09 12:44:27
ASP本周热门怎么写，本周更新怎么写啊，代码～！
我要想有的网站那样，可以本周最新情况得到统计，怎么做啊
本周和本日的原理一样吗／
我要想有的网站那样，可以本周最新情况得到统计，怎么做啊
本周和本日的原理一样吗／
'先得到今天是星期几
cweek = WeekDay(now())
sql = "select * from 表 where id > 0"
select case cweek
case 1 '星期天 本周第一天
sql = sql & " and cdate between '" & formartdatetime(now(),2) & " 00:00' and '" & formartdatetime(now(),2) & " 23:59')"
case 2 '星期一
sql = sql & " and cdate between '" & formartdatetime(now()-1,2) & " 00:00' and '" & formartdatetime(now(),2) & " 23:59')"
case 3 '星期二
sql = sql & " and cdate between '" & formartdatetime(now()-2,2) & " 00:00' and '" & formartdatetime(now(),2) & " 23:59')"
...............
case 7 '星期六
sql = sql & " and cdate between '" & formartdatetime(now()-6,2) & " 00:00' and '" & formartdatetime(now(),2) & " 23:59')"
end select
sql = sql & " order by cdate desc"
'以上语句均为MSSQL语句