主题:急急急啊,数据库
<%
set conn=server.CreateObject("adodb.connection")
conn.open "xiangqi"
set rs4=server.createobject("adodb.recordset")
rs4.open "select * from mulu where lei = '杀法'",conn
max= [color=FF0000]rs4.recordcount[/color]
response.write max
set rs2=server.CreateObject("adodb.recordset")
rs2.open "select * from mulu where ming = '三子归边'",conn
if rs2(0)=max then
response.Write "这是最后一节"
else
max=rs2(0)+1
set rs3=server.CreateObject("adodb.recordset")
rs3.open "select * from mulu where id = "&max,conn
response.write "<a href=shafa1.asp?chaxun="&rs3(3)&">"&rs3(3)&"</a>"
end if
%>
在我的库中,lei = '杀法'的记录条数应该是20条,为什么[color=FF0000]rs4.recordcount[/color]的返回值是[size=3]-1[/size]啊,我要是想返回符合[color=FF0000]lei = '杀法'[/color]的所有记录个数要用什么啊,不是[color=FF0000]recordcount[/color]吗????
盼高手指点。。。。。。[em18][em18][em18][em10][em10][em10][em10]
set conn=server.CreateObject("adodb.connection")
conn.open "xiangqi"
set rs4=server.createobject("adodb.recordset")
rs4.open "select * from mulu where lei = '杀法'",conn
max= [color=FF0000]rs4.recordcount[/color]
response.write max
set rs2=server.CreateObject("adodb.recordset")
rs2.open "select * from mulu where ming = '三子归边'",conn
if rs2(0)=max then
response.Write "这是最后一节"
else
max=rs2(0)+1
set rs3=server.CreateObject("adodb.recordset")
rs3.open "select * from mulu where id = "&max,conn
response.write "<a href=shafa1.asp?chaxun="&rs3(3)&">"&rs3(3)&"</a>"
end if
%>
在我的库中,lei = '杀法'的记录条数应该是20条,为什么[color=FF0000]rs4.recordcount[/color]的返回值是[size=3]-1[/size]啊,我要是想返回符合[color=FF0000]lei = '杀法'[/color]的所有记录个数要用什么啊,不是[color=FF0000]recordcount[/color]吗????
盼高手指点。。。。。。[em18][em18][em18][em10][em10][em10][em10]