？？如何取得文件总数

[hl2004]

这段代码是不是有问题啊，怎么不能取得总数呢？
<%
Set conn=Server.CreateObject("ADODB.Connection")
db="Database/#upload.asp"
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath(""&db&"")
set rs=conn.execute("select * from upload where PicSort="&request("PicSort")&" order by id desc")
dim totalPic
totalPic=rs.recordcount
%>

[ybcola]

<%
Set conn=Server.CreateObject("ADODB.Connection")
db="Database/#upload.asp"
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath(""&db&"")
set rs=conn.execute("select * from upload where PicSort="&request("PicSort")&" order by id desc")
dim totalPic
totalPic=rs.recordcount
%>
楼主是取得记录总数,不是文件总数
conn.exeucte方法不会返回记录集的记录总数信息,所以你以上的代码得出totalpic为-1
改成
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
totalPic=rs.recordcount

[jspadmin]

sql=select count(id) as newall * from upload where PicSort="&request("PicSort")&" order by id desc"

newall=rs("newall")
response.write newall

[hl2004]

在这里感觉到很温馨啊，有这么多热心帮助的朋友，呵呵，在这里学习真好，谢谢你们啦！！！希望以后也常常见到你们为我回帖呢！

[pbyhz]

mark