比如说一个成绩字段,在查询出某人成绩的时候同时显示此人在所有成绩中是第几名呢?
那位帮帮忙说下!!急啊```
谢谢!!!啦!~
------解决方案--------------------
<%
name=request( "name ")//你要查询的对象名子
set rs=server.createobject( "adodb.recordset ")
sql= "select * from tbl order by cj desc "
rs.open sql,conn,1,1
if rs.eof then
response.write "表为空! "
response.end
end if
dim i,s
rs.movefirst
for i=1 to rs.recordcount
if rs( "name ")=name then
response.write i
exit for
end if
rs.movenext
i=i+1
next
%>