请教一个时间段的查询语句
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
%>
请指点一下,为什么达不到目的?