recordset.recordcount return allways -1 on select statements

[Sérgio Almeida]

Greetings

On my ASP application I want to retrieve the number
(Recordset.recordCount property) of records affected by a select
statement, but I keep getting -1. Even with an example of W3Schools
(avaiable at [url]http://www.w3schools.com/ado/prop_rs_recordcount.asp[/url]) I get
-1 and not the records affected.
Here is some code (from the w3's example).

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("northwind.mdb"))
set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT * FROM Customers"
rs.Open sql,conn

if rs.Supports(adApproxPosition)=true then
i=rs.RecordCount
response.write("The number of records is: " & i)
end if
rs.Close
conn.Close
%>

What seems to be the problem?
Thanks in advance.

Sérgio

[Jeff Clark]

popular question. Your cursor is wrong. Search google - that question is
everywhere

"Sérgio Almeida" <sgalmeidaNOSPAM@bragatelNOSPAM.pt> wrote in message
news:OgpRtOnmDHA.2772@TK2MSFTNGP10.phx.gbl...

> Greetings
>
> On my ASP application I want to retrieve the number
> (Recordset.recordCount property) of records affected by a select
> statement, but I keep getting -1. Even with an example of W3Schools
> (avaiable at [url]http://www.w3schools.com/ado/prop_rs_recordcount.asp[/url]) I get
> -1 and not the records affected.
> Here is some code (from the w3's example).
>
> <%
> set conn=Server.CreateObject("ADODB.Connection")
> conn.Provider="Microsoft.Jet.OLEDB.4.0"
> conn.Open(Server.Mappath("northwind.mdb"))
> set rs=Server.CreateObject("ADODB.recordset")
> sql="SELECT * FROM Customers"
> rs.Open sql,conn
>
> if rs.Supports(adApproxPosition)=true then
> i=rs.RecordCount
> response.write("The number of records is: " & i)
> end if
> rs.Close
> conn.Close
> %>
>
> What seems to be the problem?
> Thanks in advance.
>
> Sérgio
>

[Aaron Bertrand [MVP]]

> (Recordset.recordCount property) of records affected by a select

> statement, but I keep getting -1.

[url]http://www.aspfaq.com/2193[/url]