错误类型:Microsoft JET Database Engine (0x80040E10)
<!--#include file="conn.asp" --><%
dim sql,publish_id,publish_name
publish_id=Request.Form("publish_id")
publish_name=Trim(Request.Form("publish_name"))
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from publish where publish_name='"&publish_name&"'"
rs.open sql,conn,1,3//是这行提示的错误
if not rs.eof then
response.Write"<script> alert('此学生已存在.');history.back(edit_publish.asp);</script>"
response.Redirect("edit_publish.asp")
response.End
else
rs.addnew
rs("publish_id")=publish_id
rs("publish_name")=publish_name
rs.update
rs.close
set rs=nothing
end if
response.write "<script language=jscript>alert(记录添加成功!');history.back(edit_publish.asp)</script>"
response.Redirect("edit_publish.asp")
response.End()
%>
错误类型:
Microsoft JET Database Engine (0x80040E10)
至少一个参数没有被指定值。谢谢了