为什么这个程序无法更新数据库?
我成功执行了这个,但是他却无法成功更新数据库?没有错误?很奇怪?是不是我有点语句有问题?我很菜,竟问一些简单的问题^-^
<%@LANGUAGE="VBSCRIPT"%>
<html>
<head>
<title>修改数据库记录</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#ffffff">
<center>
<%
name=request.form("name")
Classname=request.Form("class")
sex=request.form("sex")
score=request.form("score")
set Conn=Server.CreateObject("ADODB.Connection")
conn.open "test"
sqlstmt="update student "
sqlstmt=sqlstmt & " set name='" & name & "',"
sqlstmt=sqlstmt & " sex='" & sex & "',"
sqlstmt=sqlstmt & " class='" & classname & "',"
sqlstmt=sqlstmt & " score='" & score & "'"
sqlstmt=sqlstmt & " where name=' " &name& " ' "
set rs=conn.execute(sqlstmt)
if err.number>0 then
response.write "VBScript errors occured:" & "<p>"
response.write "Error Number=" & err.number & "<p>"
response.write "Error Descr.=" & err.description & "<p>"
response.write "Help Context=" & err.helpcontext & "<p>"
response.write "Help Path=" & err.helppath & "<p>"
response.write "Native Error=" & err.nativeerror & "<p>"
response.write "Source=" & err.source & "<p>"
response.write "SQLState=" & err.sqlstate & "<p>"
end if
IF conn.errors.count>0 then
response.write "Database Errors Occured" & "<p>"
response.write SQLstmt & "<P>"
for counter=0 to conn.errors.count
response.write "Error #" & conn.errors(counter).number & "<P>"
response.write "Error desc. ->" & conn.errors(counter).description & "<P>"
next
else
response.write "<font face='arial' size=4>"
response.write "<br><br>记录已经被成功修改."
response.write "<br></font>"
end if
conn.close
set conn=nothing
%>
</center>
</body>
</html>