一、时间段Access:
sql="select * from news where addtime between #"&begin_time&"# and #"&end_time&"# "
或
sql="select * from news where addtime >= #"&begin_time&"# and addtime <= #"&end_time&"# "
二、统计和查询
set rs=conn.execute=("select sum(price) from table")
response.write rs(0)
下一篇:ASP查看源代码时换行符
讨论数量:1
如是SQL Server数据库,时间段查询应该是这样:
sql="select * from news where addtime between '"&begin_time&"' and '"&end_time&"'"
也就是把“#”换成“'”