刚开始学习asp
连接数据库的时候遇到问题
我想实现数据的插入
index.asp是
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!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>
<center>社团注册</center>
<form method="post" action="cr.asp" >
社团名称： <input type="text" name="name" size="8"><br>
所在校区： <input type="text" name="schoolhouse" size="8"><br>
所属学院： <input type="text" name="academy" size="8"><br>
电子邮件： <input type="text" name="email" size="8"><br>
社团负责人：<input type="text" name="principal" size="8"><br>
负责人电话：<input type="text" name="principalcall"size="8"><br>
负责人寝室：<input type="text" name="principalroom"size="8"><br>
社团主页： <input type="text" name="blog"size="18"><br>
社团说明：<textarea rows="10" cols="25" name="others"></textarea><br>
<input type="submit" value="提交" name="a1"><input type="reset" value="重设">
</form >
</body>
</html>
插入数据库文件是：
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>数据插入</title>
<link href="index-ch.css" type="text/css" rel="stylesheet">
</head>
<body style="margin-top:2; margin-left:1; margin-right:0; margin-bottom:auto">
<%
var schoolhouse = Request("schoolhouse");
var academy=Request("academy")
var email=Request("email")
var principal=Request("principal")
int principalcall=Request("principalcall")
var principalroom=Request("principalroom")
var blog=Request("blog")
var others=Request("others")
Conn = Server.CreateObject("ADODB.Connection");
Conn.Open("driver={Microsoft Access Driver (*.mdb)};dbq=" +Server.MapPath("st.mdb"));
);
var rs =Server.CreateObject("ADODB.Recordset");
var sql = "insert into text (name,schoohouse,academy,emailprincipal,principalcall,principalroom,blog,others) values('"+name+"','"+schoolhouse+"','"+academy+"','"+emailprincipal+"','"+principalcall+"','"+principalroom+"','"+blog+"','"+others+"',)";
rs.Open(sql,Conn,3);
%>
</body>
</html>
哪位帮帮忙看看那里错了
多谢！！！！！
