Forums
This topic is locked
rs.AbsolutePage question
Posted 05 Apr 2002 08:11:23
1
has voted
05 Apr 2002 08:11:23 iouri iouri posted:
hi, I'm trying to display the number of the pages and the page the user is currently on.Typing <%=rs.AbsolutePage%> or <%=rs.PageCount%> gives me -1 on my asp page
UD set page size and gives number of records found in the recordset, but there is no server behavoir for counting pages or at least I haven't found one.
On my clean (non UD) pages <%=rs.AbsolutePage%> works.
Thanks
Replies
Replied 05 Apr 2002 14:55:24
05 Apr 2002 14:55:24 martin Scullion replied:
Sounds like you are using a forward-only (adstatic) cursor to me, u need a cursor type of either adopenkeyset Cursortype=1 or adopendynamic cursortype=2, I think those are the correct constants.