ASP + Access 查询后结果为空
<%
dim conn
dim connstr
on error resume next
connstr="DBQ="+server.mappath("mynews.asp")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
newstype=request("typeid")
sql="select * from article where shenghe=1 and typeid="+cstr(newstype)+" order by dateandtime desc"
set rs=conn.execute(sql)%>
以上代码,当request("typeid")的值为5时就查询不到,为其他值时就能正常查出来,数据表的数据保证没有问题,请高手赐教!