急等高手！！ASP查询数据记录问题？？？？
Set conn = Server.CreateObject( "ADODB.Connection ")
DBPath = Server.MapPath( "/data/main.mdb ")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq= " & DBPath


sql= "select * from books where book_name like '% " & bname & "% ' " & "AND book_sort= ' " & bsort & " ' "
Set rs=Server.CreateObject( "ADODB.Recordset ")
Set rs=conn.execute(sql)

执行过查询之后，我怎么样才能获得记录的条数？我用的是ACCESS数据库。用的是VBSCRipt。

[解决办法]
你的存在如下：

Set conn = Server.CreateObject( "ADODB.Connection ")
DBPath = Server.MapPath( "/data/main.mdb ")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq= " & DBPath


sql= "select * from books where book_name like '% " & bname & "% ' " & "AND book_sort= ' " & bsort & " ' "
Set rs=Server.CreateObject( "ADODB.Recordset ") //句下面要取一就可以
Set rs=conn.execute(sql) //句上面那句要取一就可以

如果采用Execute,要查次
如果采用RecordSet要查一次
方法如下：
一.采用Execute：
Set conn = Server.CreateObject( "ADODB.Connection ")
DBPath = Server.MapPath( "/data/main.mdb ")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq= " & DBPath


sql= "select * from books where book_name like '% " & bname & "% ' " & "AND book_sort= ' " & bsort & " ' "
sqls = "select count(*) from books where book_name like '% " & bname & "% ' " & "AND book_sort= ' " & bsort & " ' "
set rsc = conn.execute(sqls) //rsc(0)的值,就是RecordCount
set rs = conn.execute(sql)
//方法,不知道行不行,你一下看看,建使用RecordSet方法


二.采用RecordSet方法
Set conn = Server.CreateObject( "ADODB.Connection ")
DBPath = Server.MapPath( "/data/main.mdb ")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq= " & DBPath


sql= "select * from books where book_name like '% " & bname & "% ' " & "AND book_sort= ' " & bsort & " ' "
set Rs = Server.CreateObject( "ADODB.RecordSet ")
rs.open conn,sql,1,1

此方法的行：
rs.recordcount
[解决办法]
" "Set conn = Server.CreateObject( "ADODB.Connection ")
DBPath = Server.MapPath( "/data/main.mdb ")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq= " & DBPath


sql= "select * from books where book_name like '% " & bname & "% ' " & "AND book_sort= ' " & bsort & " ' "
Set rs=Server.CreateObject( "ADODB.Recordset ")
Set rs=conn.execute(sql) " "中的Set rs=conn.execute(sql)是没有用的，如果用了Set rs=Server.CreateObject( "ADODB.Recordset ")，后面就用rs.open sql,conn,1,1
然后再输出rs.recordcount就可以了。如果是要用Set rs=conn.execute(sql)，前面的Set rs=Server.CreateObject( "ADODB.Recordset ")是多余的。要取记录数直接用
set rs = conn.execute(= "select count(*) as ss from books where book_name like '% " & bname & "% ' " & "AND book_sort= ' " & bsort & " ' ")

response.write rs( "ss ")