code:
<%=RS.Rows.count%>
This returns an error. All I want to do is know how many rows in my access db. How do I do this?
Printable View
code:
<%=RS.Rows.count%>
This returns an error. All I want to do is know how many rows in my access db. How do I do this?
Try <%=RS.RecordCount%>
;)
This returns -1 for me. I looked through the sight and came up with this loosing answer:
<% RS.movelast%>
<% =RS.RecordCount%><br>
<% RS.movefirst%>
<% =RS.fields.Count-1%><br>
THIS DOESN'T WORK. I get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e24'
The rowset does not support fetching backwards
/HelpMeWith/My.asp, line 163
PLEASE HELP!
1) Make sure you are using a cursortype other than adOpenForwardOnly.
2) Make sure you are using a client side cursor location.
3) Do a movelast then a movefirst then check recordcount.
Just FYI- According to Microsoft, recordcount is only 100% accurate when the recordset is based on a table and not a query.