micmic2
07-22-2003, 01:35 PM
I want to page through a recordest "rs"
during my loop i call to a faction that open a new recordest "rs2"
my code works but sometimes the list repeat itself as if the pointer goes back a few items
any ideas how to solve it?
part of my code-
intRec=0
adUseClient=3
rs.CursorLocation = adUseClient
do while (intRec<rs.pagesize) and (not rs.eof)
intRec=intRec+1
function()
response.write rs("name")
rs.MoveNext
loop
example -
first page:
1
2
3
4
second page:
3
4
5
6
instead of-
first page:
1
2
3
4
second page:
5
6
during my loop i call to a faction that open a new recordest "rs2"
my code works but sometimes the list repeat itself as if the pointer goes back a few items
any ideas how to solve it?
part of my code-
intRec=0
adUseClient=3
rs.CursorLocation = adUseClient
do while (intRec<rs.pagesize) and (not rs.eof)
intRec=intRec+1
function()
response.write rs("name")
rs.MoveNext
loop
example -
first page:
1
2
3
4
second page:
3
4
5
6
instead of-
first page:
1
2
3
4
second page:
5
6