sql执行不了。。在access下就可以执行,为什么?
<%sql1="select * from ts where uptime <= cdate(""2011-8-6"") order by uptime desc"
Response.Write (sql1)
rs.open sql1,conn,1,1
on error resume next
maxjilu=rs.recordcount
Response.Write (maxjilu)
%>
用了cdate这个就不用,换别的sql就正常,为什么?在access里直接查询就行,为什么?怎么处理?