add.asp
=====================
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<form name="form" method="post" action="add_new.asp">
类型 <select name="main_no">
<option value="1">a</option>
<option value="2">b</option>
<option value="3">c</option>
</select><br>
标题 <input type="text" name="title"><br>
推荐指数<input type="text" name="star" ><br>
地址<input type="text" name="url" ><br>
<input type="submit" name="Submit" value="提交">
<input type="reset" name="Submit2" value="重置">
</form>
</body>
</html>
=======================================================
add_new.asp
===============
<%
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("\DB\ADB.mdb")
%>
<%
main_no=request.form("main_no")
title=request.form("title")
star=request.form("star")
url=request.form("url")
exec="insert into main(mainNO,title,Star,URL) values('"+main_no+"','"+title+"','"+star+"','"+url+"')"
conn.execute exec
conn.Close()
Set conn = Nothing
response.redirect "administer.asp"
%>
================
我把
conn.execute exec
conn.Close()
Set conn = Nothing
这三行去掉能跳转至administer.asp
但数据库自然没写入··