asp的recordset查错,高手请进

来源：百度知道 编辑：UC知道 时间：2024/06/23 19:17:15
请高手帮我解释一下是什么错了!
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.connectionstring="driver={SQL Server};Server=CHWAIN\WAIN;UID=sa;PWD=sa123;database=Talking"
conn.open
response.Write "conn.state:"& conn.state & vbCR
set RS=Server.CreateObject("ADODB.Recordset")
SQLString="select * from Friends"
set RS=conn.Execute(SQLString)
rs.open
rs.addnew
rs("num")=10
rs("name")="Chen"
rs("sex")="男"
rs("birthday")="1986-05-21"
rs("age")=23
rs.update
RS.movefirst
response.Write("<table>")
do while not RS.eof
response.Write("<tr>")
for i= 0 to RS.fields.count-1
response.Write("<td>"&rs(i)&"</td>")
next
response.Write"</tr>"
RS.movenext
loop
respon

改成这样试试，因为用conn.Execute(SQLString) 时，数据库是以只读方式打开，而且游标不能往回移动，只能向后移动，改用rs.open SQLString,conn,1,3
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.connectionstring="driver={SQL Server};Server=CHWAIN\WAIN;UID=sa;PWD=sa123;database=Talking"
conn.open
response.Write "conn.state:"& conn.state & vbCR
set RS=Server.CreateObject("ADODB.Recordset")
SQLString="select * from Friends"
rs.open SQLString,conn,1,3
rs.addnew
rs("num")=10
rs("name")="Chen"
rs("sex")="男"
rs("birthday")="1986-05-21"
rs("age")=23
rs.update
RS.movefirst
response.Write("<table>")
do while not RS.eof
response.Write("<tr>")
for i= 0 to RS.fields.count-1
response.Write("<td>"&rs(i)&"</td>")