Access数据库日期访问的问题

[youmh]

Access数据库，数据类型为 ShortDate

查询的时候用 select * from tbTest where pubdate ='2003-10-21' 日期形式的查询不出来

返回的是错误

用 select * from tbTest where pubdate =2003-10-21 日期形式查询的时候，返回空的结果集


请问这个是什么问题，怎么解决？

[bineon]

try
＃2003-10-21＃

——————————————————————————————————
www.91asp.cn
有时间到这里找资料找书籍，你会发现asp以及.net很容易！
前提是你努力学习！

[liuguozhong]

select * from tbTbtest where pubdate='#2003-10-21#'

[gmlxf]

你在asp中打印select pubdate from tbTest出来看看
，看看pubdate显示的格式。
select * from tbTest where pubdate ='2003-10-21'

[youmh]

<!--#include file="conn.asp" -->

<%
dim rs,sql

set rs = server.createobject("ADODB.RecordSet")
sql = "select * from tbOrder where partid=1"
rs.open sql,conn,1,1
response.write rs("OrderDate")

rs.close
sql = "select * from tbOrder where OrderDate = '2003-10-21'"
rs.open sql,conn,1,1
response.write rs("partid")

rs.close
sql = "select * from tbOrder where OrderDate = '#2003-10-21#'"
rs.open sql,conn,1,1
response.write rs("partid")

%>

返回结果第一个为正常的 2003-10-21
第二个和第三个返回提示 ：

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
ODBC 驱动程序不支持所需的属性。

[eduxh]

sql = "select * from tbOrder where OrderDate = #2003-10-21#"

[aBoris]

Access:
sql = "select * from tbOrder where OrderDate = #2003-10-21#"
SQL Server:
sql = "select * from tbOrder where OrderDate = '2003-10-21'"

[srj911]

select * from tbTbtest where pubdate='#2003-10-21#'