<!--#include file="conn.asp"-->
<!--#include file="md5.asp"-->

<%
username1=request.form("person1")
pwd1=md5(request.form("person1"))
oskey1=request.form("oskey1")
quanxian1=request.form("quanxian1")
set irs=server.createobject("adodb.recordset")
sql1="select * from teacher "
sql2="select * from user "
irs.open sql1,conn,1,3
irs.addnew
irs("username")=username1
irs("passwd")=pwd1
irs("oskey")=oskey1
irs("quanxian")=quanxian1
irs.update
irs.close
irs.open sql2,conn,1,3
irs.addnew
irs("username")=username1
irs("userpass")=pwd1
irs.update
irs.close
set irs=nothing %>


其中,teacher表中可以写入数据,user表中却写不进,不知为什么,请高手帮忙

conn.Execute( "insert into [User] (UserName,Userpass,UserGroupID,Members,Levelname) values('"&username1&"','"&pwd1&"',"&27&",'本校老师','本校老师')" )
与上面什么区别