next record link

[fran7]

Hi, I wonder if anyone could point me in the right direction. I have this script that gets a random record from my database. All records have an id, how do I instead of random just go to the next record?
Any pointers would be great.
Thanks
Richard

<% 
' ADO Constant. Dont change this 
' Connection string and SQL statement 
 
sql  = "Select artist,largeimageseven  FROM tblGreet where largeimageseven = 'yes'"
connStr = " Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/fpdb/greetingcardpro.mdb" ) 
' Opening database 
 
Set rs = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, connStr, 3, , adCmdText 
' Generating random number from total number of records 
 
Randomize Timer 
intRnd = (Int(RND * rs.RecordCount)) 
' Now moving the cursor to random record number 
rs.Move intRnd 
' Showing the random statement 
Response.Write "<span span style=""float: right;""><a href=""/artist.asp?artist=" & rs("artist") & """>next&nbsp; <img src=""plusright.gif"" border=""0""></a></span>"
' Closing the database 
rs.Close 
Set rs = Nothing 
%>

[idsanjeev]

Hello
Add order by in sql statement to arrange your records with id or other column wise.
like-

sql=selec *from  tablename where column=columnname order by columnname

regards
jha

[DrBunchman]

Hi Richard,

Use

rs.MoveNext

to move to the next record.

Hope this helps,

Dr B