SQL语句语法错误,恳请支持!!!
用asp+access做网页,access数据中包括一张表(event),
包含字段:e_creattime,e_status,e_number .......
需要实现功能:
用SQL语句实现查找某个时间段内的记录,但是用如下语句出现语法报错:
sql = "select * from event where creattime<=#"&date&"# && creattime>#"&date-1&"# and <>'close' order by number desc"
creattime<=#"&date&"# && creattime>#"&date-1&"# 语法错误.
请问应该怎么写,各位帮帮忙!感激不尽!
问题点数：10、回复次数：5Top
1 楼sy_binbin（）回复于 2006-06-02 16:48:18 得分 0
creattime<=#"&date&"# && creattime>#"&date-1&"#
creattime<=#"&date&"# and creattime>#"&date-1&"#Top
2 楼itzhiren（itzhiren）回复于 2006-06-02 16:49:56 得分 0
sql = "select * from event where creattime<=#"&date&"# && creattime>#"&date-1&"# and <>'close' order by number desc"
creattime<=#"&date&"# && creattime>#"&date-1&"# 语法错误.
这条语句问题很多，不光是creattime<=#"&date&"# && creattime>#"&date-1&"# ，还有and <>'close'
<>'close'前面怎么没有字段名？！Top
3 楼sotwind（醉风）回复于 2006-06-02 16:54:07 得分 0
sql = "select * from event where creattime between #"&date&"# and #"&date-1&"# and 什么<>'" & close & "' order by number desc"
没明白Top
4 楼playwarcraft（时间就像乳沟,挤挤还是有的）回复于 2006-06-02 16:57:57 得分 0
sql = "select * from event where creattime<=#"&date&"# && creattime>#"&date-1&"# and <>'close' order by number desc"
&&改為and , 'close'前面沒字段名,&date-1&是什麼?變量嗎?如果只是date是變量,可以直接-1嗎??Top
5 楼sotwind（醉风）回复于 2006-06-02 17:14:22 得分 0
不能噢 date也是函数
应该用 dateadd函数计算时间
刚才我也疏忽了 呵呵Top
