Very Computer

Hi,

I need to know how many records there are in a ado-recordset: i did this:
<%
Set objDC = Server.CreateObject("ADODB.Connection")
ObjDC.open = "provider=msdasql; driver={microsoft access driver (*.mdb)};
dbq=c:\inetpub\wwwroot\res.mdb"

sql="select name from studres where ... ;"
set rs=objDC.execute(sql)

rec=rs.recordcount
response.write(rec)
%>

but i always get -1 !

Any reason for this and how to get the real amount?
Thanks
fil

Quote:> I need to know how many records there are in a ado-recordset: i did this:
> <%
> Set objDC = Server.CreateObject("ADODB.Connection")
> ObjDC.open = "provider=msdasql; driver={microsoft access driver (*.mdb)};
> dbq=c:\inetpub\wwwroot\res.mdb"

> sql="select name from studres where ... ;"
> set rs=objDC.execute(sql)

> rec=rs.recordcount
> response.write(rec)
> %>

> but i always get -1 !

--

Thanks,
Carl Prothman
Microsoft Visual Basic MVP
http://www.able-consulting.com

I believe you need a
rs.movelast
rec = rs.recordcount

alternatively you can try the following query
select count(*) from table
That should return the number of rows.

Haim Katz