主题:  请教一个时间段的查询语句

lxyyx

职务:普通成员
等级:1
金币:0.0
发贴:19
注册:2004/6/14 9:04:51
#12004/12/23 11:53:35
请教一个时间段的查询语句
DGTime字段为日期/时间
目的:查询指定时间内的纪录(就显示前ddd月的纪录)DW2004 ASP代码如下
<%
Dim rs_user__MMColParam,ddd
ddd=-10
rs_user__MMColParam = dateadd("m",ddd,Date ())
%>
<%= rs_user__MMColParam %>
<%
Dim rs_user
Dim rs_user_numRows

Set rs_user = Server.CreateObject("ADODB.Recordset"
rs_user.ActiveConnection = MM_tzycoon_STRING
rs_user.Source = "SELECT DGTime FROM user WHERE DGTime > " + Replace(rs_user__MMColParam, "'", "''" + ""rs_user.CursorType = 0
rs_user.CursorLocation = 2
rs_user.LockType = 1
rs_user.Open()

rs_user_numRows = 0
%>
请指点一下,为什么达不到目的?