hi everyone,
i need to move next record, in some case not in order...
eg.100,101,103,106, with assumption that record 104,105 have been
deleted... i have tried the following but fail, please help thanks...
Set rs=server.createobject("ADODB.Recordset")
sql="select * from leavepending"
rs.ActiveConnection = strconnect
rs.Source = Sql
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 3
rs.Open()
if request.form="" then
rs.movefirst
end if
If request.form("combutton")="NEXT" Then
rs2.movenext
End If
If request.form("combutton")="BACK" Then
rs2.moveprevious
End If
<input type="text" name="leaveid" size="30" value="<% =rs2
("numid").value %>">
but base on my code,it can only move ONCE only,eg.100 move to 101,
keep on 'Next' won't move to 103, just remain 101.... please help, i
am really stuck, i can't find any referece on this.....thanks..
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM
---------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
