问一个ASP的问题,为什么我的代码执行了没反应,求高手
addnews.asp
<!-- #include file="conn.asp" -->
<%
if request("action")="add" then
sql="select * from news"
set rs=Server.CreateObject("Adodb.Recordset")
rs.open sql,conn,1,3
rs.addnew
rs("class1")=trim(request.form("class1"))
rs("title")=trim(request.form("title"))
rs("content")=trim(request.form("content"))
rs("addtime")=trim(request.form("addtime"))
rs.update
rs.close
set rs=nothing
conn.close
end if
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<form action="addnews.asp?action=add" method="post">
<table border="1">
<tr><td>题目:</td>
<td><input type="text" name="title" size="70"/></td>
</tr>
<tr><td>内容:</td><td><textarea name="content" rows="20" cols="70"></textarea></td></tr>
<input type="hidden" value="now()" name="addtime"/>
<tr><td>板块:</td><td>
<select name="class1">
<option>11</option>
<option>2222</option>
</select>
</td></tr>
<tr><td> </td><td><input type="submit" value="添加" /></td></tr>
</table>
</form>
</body>
</html>
conn.asp的代码
<%
dim conn
dim connstr
dim db
db="../DB/#Data.mdb" '数据库文件位置
on error resume next
connstr="DBQ="+server.mappath(""&db&"")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=server.createobject("ADODB.CONNECTION")
if err then
err.clear
else
conn.open connstr
end if
%>
问题是,我执行了添加代码,没有报错,但数据库没有数据插入,是为什么啊?