Question

ASP错误 标准表达式中数据类型不匹配

运行的时候提示Microsoft JET Database Engine 错误 '80040e07'
标准表达式中数据类型不匹配

请高手帮忙检查一下是哪里出问题了,我太菜看不出来.

<%
dim id
id = request("id")
Set rs = Server.CreateObject ("ADODB.Recordset")
sql = "Select * from info where id='&id&'"
rs.Open sql,conn,3,1
%>
<%
if rs.EOF and rs.BOF then
response.write("维护中！")
else
response.write("123123")
rs.MoveNext
End if
rs.close
Set rs = Nothing
conn.close
set conn = Nothing
%>
id字段为数据库自动编号

Answer 1

sql = "Select * from info where id='&id&'"
rs.Open sql,conn,3,1

改为

sql = "Select * from info where id="&id
rs.Open sql,conn,3,3

对于百度消息补充：

应该是请求的id没有得到值

即id的值为空

可以这样写:

<%
dim id
id = request("id")
if id="" then
response.wirte "<script>alert('id值为空');</script>"
response.end
end if
id=cint(id)
Set rs = Server.CreateObject ("ADODB.Recordset")
sql = "Select * from info where id="&id
rs.Open sql,conn,3,3
%>

要是回答的内容有问题，或认为不妥，请发送百度消息给我，消息内容加上本页网址哦。。

·

Answer 2

sql = "Select * from info where id='&id&'"
如果数据库info的id字段为数字类型则
sql = "Select * from info where id=" &id
如果数据库info的id字段为字符串类型则
sql = "Select * from info where id='" &id & "'"