一个有时间的筛选问题。分一次送完

[qjx6531]

我是用DW来做网页的，现在要提一个比当前时间大的记录集。也就是一个广告到期了，就不显示了的意思。我的数据表名称是gg，记录时间的字段是gg_0。我该怎么做啊，写where后咋写啊。55555
以下是代码
<%
Dim rsgg__MMColParam
rsgg__MMColParam = "1"
If (Request.QueryString("gg_0") <> "") Then
rsgg__MMColParam = Request.QueryString("gg_0")
End If
%>
<%
Dim rsgg
Dim rsgg_numRows

Set rsgg = Server.CreateObject("ADODB.Recordset")
rsgg.ActiveConnection = MM_gg_STRING
rsgg.Source = "SELECT * FROM dbo.gg WHERE gg_0 > '" + Replace(rsgg__MMColParam, "'", "''") + "'"
rsgg.CursorType = 0
rsgg.CursorLocation = 2
rsgg.LockType = 1
rsgg.Open()

rsgg_numRows = 0
%>

[qjx6531]

没有人来么

[hookee]

ACCESS
"SELECT * FROM dbo.gg WHERE DATEDIFF('d',gg_0,#" & Replace(rsgg__MMColParam, "'", "''") & "#)<=0"

SQL SERVER
"SELECT * FROM dbo.gg WHERE DATEDIFF(d,gg_0,'" & Replace(rsgg__MMColParam, "'", "''") & "')<=0"

[qjx6531]

我用的是sql 2000.

[qjx6531]

我用的是sql 2000.提大于当前时间的记录集。能说明白点么

[qjx6531]

Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp，行242

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]从字符串转换为 datetime 时发生语法错误。

/shiyan/daoqishijian.asp，行20

[hookee]

rsgg__MMColParam的值是什么？