asp的addnew出错,请大侠帮忙,困扰好几天了。
addnew.asp------------------------------------------------------------------
<!--#include file="./conn.asp" -->
<%
'On Error Resume Next
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "select * from cgsqd"
rs.open sql,conn,1,3
rs.addnew
rs("name")=Request.form("name")
rs("dept")=Request.form("dept")
rs("num")=Request.form("num")
rs("date")=Request.form("date")
rs.update
If Err Then
Err.Clear
rs.close
Set rs = nothing
response.write "插入失败..."
response.write Err.Description
response.write Err.Number
Response.End()
End If
Response.Write "<html><body><center><font size=5>祝贺,您的申请单已经添加进数据库了!<p>"
------------------------------------------------------------------
错误信息:
You are not authorized to view this page
You do not have permission to view this directory or page using the credentials you supplied.
------------------------------------------------------
已知的
1.因为有别的asp对数据库的另一个user表能更新密码,数据库权限应该没问题。
2.表名,字段名,form的输入框名再三确认没问题。