Question

出错：标准表达式中数据类型不匹配，

<%
if request("time") = "uptime" then
selecttime = request("selecttime")
sql = "SELECT * FROM xygl where year(a26) = "&year(selecttime)&" and month(a26) = "&month(selecttime)&" ORDER BY a26 DESC"
elseif request("time") = "uptime1" then
selecttime1 = request("selecttime1")
sql = "SELECT * FROM xygl where year(a26) = "&year(selecttime1)&" and month(a26) = "&month(selecttime1)&" and day(a26) = "&day(selecttime1)&" ORDER BY a26 DESC"
elseif request("time") = "time" then
sql = "SELECT * FROM xygl where a26 = '"&request("timeinfo")&"' ORDER BY a26 DESC"
else
sql="SELECT * FROM xygl where year(a26) = year(now()) and month(a26) = month(now()) ORDER BY a26 DESC"
end if
set rs=conn.execute(sql)
'response.write(sql)
i = 1
do while not rs.eof
%>

提示：
Microsoft JET Database Engine错误 '80040e07'
标准表达式中数据类型不匹配。
personlist.asp，行 83

Answer 1

先确认一下你的a26字段的数据类型,如果是文本型的,那么year(a26)就是错误的,因为year()函数要求参数是一个日期型数据.而如果a26是日期型,那么另外一个查询中的a26 = '"&request("timeinfo")&"' 查询条件指定的是字符串条件,也是错误的.
所以,首先要确定是哪种数据类型所造成的错误,如果是第一种情况,可以试试year(cdate(a26)),当然,你的a26字段必须是有效的日期型文本(除此之外还有month,day两个函数).如果是第二种情况且使用Access数据库,那么,将单引号改为#号.