<!--#include file = include/conn.asp-->
<%
id=Trim(Request.QueryString("id"))
if id="" then
sql="select * from uttermost where lm in(snxw,gnxw,bdxw) order by id desc"
else
id=int(id)
sql="select * from uttermost where id="&id
end if
set rss=Server.CreateObject("Adodb.Recordset")
rs.open sql,conn,1,3
%>
在我没有参数提交时,怎么会出现如下错误呢?
sql="select * from uttermost where lm in(snxw,gnxw,bdxw) order by id desc" 这条语句那里有错吗?都是这里的原因、1
Microsoft OLE DB Provider for ODBC Drivers 错误 80040e10
[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 2。
/news/manageNews/main.asp,行11
sql="select * from uttermost where lm in(snxw,gnxw,bdxw) order by id desc"
改成:sql="select * from uttermost where lm in(snxw,gnxw,bdxw) order by id desc"
sql="select * from uttermost where lm like %xw% order by id desc"