新手,请大虾指正!--急,在线等!
<html>
<head>
<title>数据库添加记录</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="">
<table width="400" height="100" border="1">
<tr>
<td><div align="right">用户名:</div></td>
<td><input name="text1" type="text" id="text1" /></td>
</tr>
<tr>
<td><div align="right">密码:</div></td>
<td><input name="text2" type="password" id="text2" /></td>
</tr>
<tr>
<td align="right"><input type="submit" name="Submit1" value="提交" />
<script language="vbscript">
<!--
Sub Sumbit1_OnClick
dim cnn,sSql
set cnn = Server.CreateObject("ADODB.connection")
cnn.ConnectionString = "PROVIDER=SQLOLEDB;DATA SOURCE=LUJIANFANG;UID=sa;PWD=sa;DATABASE=Sell"
cnn.open
sSql="insert aaa(aa,bb) values('" & text1 & "','" & text2 & "')"
cnn.Execute(sSql, , adCmdtext)
End Sub
-->
</script>
</td>
<td><input type="reset" name="Submit2" value="重置" /></td>
</tr>
</table>
</form>
</body>
</html>
上面的代码在哪边出错了。怎么才能把文本框中的添加到表里去。