i have an application that searches records from a database, sometimes the recors are too many and i want to brake them into individual pages showing a max of 10 records per page. i tried using paging recordset feature from dreamweaver but it does not work well, it repeats records.
Please help me with any code that i can impletemt, here is the connection and query:
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
set MM_objConn_STRING=server.CreateObject("ADODB.conne ction")
MM_objConn_STRING.open = "Provider=SQLOLEDB.1;DataSource=datatest\INST1;Dat abase=datatest;uid=user_namewd=password;Network Library=DBMSSOCN;"
Recordset1.ActiveConnection = MM_objConn_STRING
Recordset1.Source = "SELECT idmum,namefirst,namelast,namemiddle FROM tbl_test where namelast like 'smith' "
If you use MySQL, at the end of your SELECT statement you can put in LIMIT x, y
where x is the starting point and y is the number of records you want. SO what you can do is keep track of where the user is i.e. viewing 11 - 20, x = 11, if they click next, x = 21. (I assume y will always be 10).