急,在线等,日期问题

[jiangxiaochao]

var aVisit;
sSqlString = "select CreateTime,PageUrl,RefUrl,ip,region,linktype,ClientInfo "
+ "from t_visit where SiteId=" + iSiteId + " order by id desc";
var oRs = new ActiveXObject("ADODB.Recordset");
with(oRs){
PageSize = DefaultPageSize;
open(sSqlString,oConn,1,3);
var iPageCount = PageCount;
var iRecCount = RecordCount;
var iPage = parseInt(Request.QueryString("p")+'');
if(isNaN(iPage)||iPage<1) iPage=1;
if(iPage>iPageCount) iPage=iPageCount;
if(!EOF){
AbsolutePage = iPage;
aVisit = GetRows(100);
}
close();
}
========================================
sSqlString = "select CreateTime,PageUrl,RefUrl,ip,region,linktype,ClientInfo "
+ "from t_visit where SiteId=" + iSiteId + " order by id desc";
如何把这语句改为只选择当天的记录?

[Yansharp]

t_visit 这个表中应该有一个字段存储日期

[jiangxiaochao]

是的.creattime这个字段

[Yansharp]

sSqlString = "select CreateTime,PageUrl,RefUrl,ip,region,linktype,ClientInfo "
+ "from t_visit where SiteId=" + iSiteId + " and datediff(d,creattime,'"+now()+"')=0 order by id desc";
如果你的数据库是sql server

[jiangxiaochao]

我的是access呀

[Yansharp]

也应该可以，如果sql语句有问题，把now()改成now,再看看，我不记得了

[Yansharp]

你用的是什么语言？如果是asp，则是now,如果是javascript,则应该是new date()