Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e10'
[Microsoft][ODBC Microsoft Access Driver]COUNT 字段不正确
/admin/admin_news.asp，行24
<%
work=Request("work")
dome=Request("dome")
types=Request("types")
If Request("IN_yn")="yes" then
IN_yn=true
else
IN_yn=false
end if
IF work="add" Then
sql="insert into HN_info (IN_dome,IN_type,IN_yn) values ('"&dome&"','"&types&"','"&IN_yn&"')"
24句 Conn.execute(sql)
Response.Write "<SCRIPT LANGUAGE='JavaScript'>"
Response.Write "alert('信息添加成功');"
Response.Write "</SCRIPT>"
End IF
IF work="del" Then
sql="delete from HN_info where IN_type="&Request("types")&" and IN_id="&Request("id")
Conn.execute(sql)
Response.Write "<SCRIPT LANGUAGE='JavaScript'>"
Response.Write "alert('信息删除成功');"
Response.Write "</SCRIPT>"
End IF
IF work="upedit" Then
If Request("IN_yn")="yes" then
IN_yn=true
else
IN_yn=false
end if
sql="update HN_info set IN_dome='"&Request("dome")&"',IN_yn="&IN_yn&" where IN_type="&Request("types")&" and IN_id="&Request("id")
Conn.execute(sql)
Response.Write "<SCRIPT LANGUAGE='JavaScript'>"
Response.Write "alert('信息更新成功');"
Response.Write "</SCRIPT>"
End IF
再添加时,不能执行语句那里报错,该怎样改呢
