代码:<form action="123.asp" method="post" enctype="multipart/form-data" name="form1">标题:<input type="text" name="titl"><br>电话:<input type="text" name="tel"> 传真:<input type="text" name="fax"> 地址:<input type="text" name="add"> E-mail:<input type="text" name="mail"><br>留言:<br><div align="center"><input type="text" width="500" height="200"name="cont"></div><br><div align="center"><input type="submit" name="Submit" value="提交"> <input type="reset" name="Submit2" value="重置"></div></form><%set conn=server.createobject("adodb.connection")conn.open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.MapPath("/note-b.mdb")tit=request.form("titl")tel=request.form("tel")fax=request.form("fax")add=request.form("add")email=request.form("mail")cont=request.form("cont")exec="insert into note-board (id,tit,tel,add,cont,email,fax) values ('' ,'"&titl&"','"&tel&"','"&add&"','"&cont&"','"&mail&"','"&fax&"')"conn.execute execconn.closeset conn=nothingresponse.write "记录添加成功!"%></body><!--#include file="copyright.asp"--></html><%rs.closeset rs=nothingconn.closeset conn=nothing%>
參考答案:<form action="123.asp" method="post" enctype="multipart/form-data" name="form1">
-->
<form action="123.asp" method="post" name="form1">
-------------------------------------------------
enctype="multipart/form-data"是当表单里有文件需要上传的时候才设置,并且设置了之后不能再通过 Request.Form()取值
另:填写的各项值是否为空未做判断,如果数据库里不允许插入空字段仍会出错