Asp Javascript language paging larger database record sets
i am firmiliar with asp javascript and not asp VB.
i can display the results ok, but if i return 100 records from my table
i would like it to display 5 records per page. i have looked at asp
recordset paging on several sites, however cannot find any scripts that
work with ASP JAVASCRIPT.
can anyone help??????????? ??????????????
below is the code that i have used in my pages
email me zf*******@hotma il.com
thanks zibby1199
Database Connection File
------------------------------------------------------------------------------------------------------------------------------------------
<%@ LANGUAGE="JAVAS CRIPT" %>
<%
myconn=Server.C reateObject("AD ODB.connection" );
mydb = "Driver={Micros oft Access Driver
(*.mdb)};DBQ=c: \\onlinedata\\w ebs\\PhoneUnloc kers.net\\test\ \BizOpps\\BizOp ps.mdb";
myconn.Open (mydb);
rs = Server.CreateOb ject("ADODB.Rec ordset");
%>
------------------------------------------------------------------------------------------------------------------------------------------
Display Page
------------------------------------------------------------------------------------------------------------------------------------------
<%
sql = "Select * from tblUser" ;
rs=myconn.Execu te(sql);
while (!rs.eof)
{
%>
Name: <%=rs("Name")%> ,
DOB: <%=rs("DOB")% >,
Address: <%=rs("Address" )%>
<%
rs.movenext();
}
rs.Close();
%>
------------------------------------------------------------------------------------------------------------------------------------------