<%
dim uid
uid=request.querystring("userid")
sql="select * from users where userid ='"&uid&"'"
set conn=server.createobject("adodb.connection")
conn.open="Driver={Microsoft Access Driver (*.mdb)}; DBQ="&server.MapPath("my.mdb")
set rs=server.createobject("adodb.recordset")
set rs=conn.execute (sql)
if rs.eof then
response.write"<h2>不存在此用户名!</h2>"
else
%>
运行时提示
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e07'
[Microsoft][ODBC Microsoft Access Driver] 标准表达式中数据类型不匹配。
set rs=conn.execute (sql) 行 8
怎么回事啊?
麻烦高手帮忙看看!谢谢
dim uid
uid=request.querystring("userid")
sql="select * from users where userid ='"&uid&"'"
set conn=server.createobject("adodb.connection")
conn.open="Driver={Microsoft Access Driver (*.mdb)}; DBQ="&server.MapPath("my.mdb")
set rs=server.createobject("adodb.recordset")
set rs=conn.execute (sql)
if rs.eof then
response.write"<h2>不存在此用户名!</h2>"
else
%>
运行时提示
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e07'
[Microsoft][ODBC Microsoft Access Driver] 标准表达式中数据类型不匹配。
set rs=conn.execute (sql) 行 8
怎么回事啊?
麻烦高手帮忙看看!谢谢