<!--#include file= "admin_conndb.asp " -->
<%
teachno1=request.form( "teachno ")
teachname=request.form( "teachername ")
sex=request.form( "gender ")
teachtype1=request.form( "teachtype ")
birthday1=cdate(request.Form( "date "))
abouts1=request.form( "detail ")
set rs=server.CreateObject( "ADODB.RecordSet ")
sqlstr= "insert into teachers(teachno,teachname,teachtype,sex,birthday,abouts) values ( "&teachno1& ", ' "&teachname& " ', ' "&teachtype1& " ', ' "&sex& " ', ' "&birthday1& " ', ' "&abouts1& " ') "
rs.open sqlstr,conndb,3,2
set rs=nothing
set conndb=nothing
%>
<script language = Javascript>
<!--
alert( "讲师添加成功！ ");
window.location= "teacher.asp "
//-->
</script>
如题,加上rs.close就不行,不用关闭数据集么?
另外, "rs.open sqlstr,conndb,3,2 "这句,这样写没什么问题吧?
------解决方案--------------------
对数据库操作的顺序
1 conn.open
2 rs.open
3 rs.close
set rs=nothing
4 conn.close
set conn
------解决方案--------------------
直接把
rs.open sqlstr,conndb,3,2
rs.close
set rs=nothing
set conndb=nothing
换掉 conndb.execute(sqlstr)好了
或者，因为是插入操作
sqlstr = "select * from teachers where 1=2 "
rs.open sqlstr ,3,3
rs.addnew
rs( "teachno ") = teachno1
...
rs.update
rs.close
conndb.close