UC知道请教ASP高手，简单的ASP问题！
来源：百度知道 编辑：UC知道 时间：2024/04/28 02:15:08
<!--#include file="inc/conn.asp"-->
<%
dim biaoti,neirong
biaoti=request.form("bt")
neirong=request.form("nr")
set rs=server.createobject("adodb.recordset")
set rs1=server.createobject("adodb.recordset")
sql="select * from mytable"
rs.Open sql,conn,1,3
if rs.EOF or rs.bof then
sql="insert into mytable(biaoti,neirong) values(biaoti,neirong)"
rs.update
rs1.Open sql,conn,1,1
response.write "<script language=JavaScript>" & chr(13) & "alert('news add successful！');"&"window.location.href = 'index.asp'"&" </script>"
end if
rs.Close
set rs=nothing
%>
写如数据库的，但是什么反映的没有！
谢谢，鬼火狼烟，错误不在这里！
<%
dim biaoti,neirong
biaoti=request.form("bt")
neirong=request.form("nr")
set rs=server.createobject("adodb.recordset")
set rs1=server.createobject("adodb.recordset")
sql="select * from mytable"
rs.Open sql,conn,1,3
if rs.EOF or rs.bof then
sql="insert into mytable(biaoti,neirong) values(biaoti,neirong)"
rs.update
rs1.Open sql,conn,1,1
response.write "<script language=JavaScript>" & chr(13) & "alert('news add successful！');"&"window.location.href = 'index.asp'"&" </script>"
end if
rs.Close
set rs=nothing
%>
写如数据库的，但是什么反映的没有！
谢谢，鬼火狼烟，错误不在这里！
帮你改了一下 ... 试试看能不能看懂 ...?
<!--#include file="inc/conn.asp"-->
<%
dim biaoti,neirong
biaoti=request.form("bt")
neirong=request.form("nr")
set rs=server.createobject("adodb.recordset")
sql="select * from mytable"
rs.Open sql,conn,3,2
rs.addnew
rs("biaoti") = biaoti
rs("neirong") = neirong
rs.update
response.write "<script language=JavaScript>" & chr(13) & "alert('news add successful！');"&"window.location.href = 'index.asp'"&" </script>"
rs.Close
set rs=nothing
%>
完全不用 Rs1 的 ...
rs1.Open sql,conn,1,1
改成 rs1.Open sql,conn,1,3
response.write "<script language=JavaScript>" & chr(13) & "alert('news add successful！');"&"window.location.href = 'index.asp'"&" </s