Problem with RecordSet.RecordCount

[ralphtrent]

Hi I keep getting -1 when I call rs.recordcount, Why?

set rs=Server.CreateObject("ADODB.Recordset&quot
rs.CursorType = 3
rs.open sql,conn
response.write(&quot;<th>Total Records Found: &quot;&rs.RecordCount&&quot;</th>&quot%>

The rest of the code works fine, its just when I try to return the total records returned. I am using Sybase Database. Let me know if you need further data.

 

[Veep]

http://www.aspfaq.com/show.asp?id=2193

 

[onpnt]

search the forum for the question. It has been answered multiple times also

_____________________________________________________________________
[sub]You can accomplish anything in life, provided that you do not mind who gets credit.
Harry S. Truman[/sub]

http://www.onpntwebdesigns.com