Z
zfarooq01
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 (e-mail address removed)
thanks zibby1199
Database Connection File
------------------------------------------------------------------------------------------------------------------------------------------
<%@ LANGUAGE="JAVASCRIPT" %>
<%
myconn=Server.CreateObject("ADODB.connection");
mydb = "Driver={Microsoft Access Driver
(*.mdb)};DBQ=c:\\onlinedata\\webs\\PhoneUnlockers.net\\test\\BizOpps\\BizOpps.mdb";
myconn.Open (mydb);
rs = Server.CreateObject("ADODB.Recordset");
%>
------------------------------------------------------------------------------------------------------------------------------------------
Display Page
------------------------------------------------------------------------------------------------------------------------------------------
<%
sql = "Select * from tblUser" ;
rs=myconn.Execute(sql);
while (!rs.eof)
{
%>
Name: <%=rs("Name")%>,
DOB: <%=rs("DOB")%>,
Address: <%=rs("Address")%>
<%
rs.movenext();
}
rs.Close();
%>
------------------------------------------------------------------------------------------------------------------------------------------
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 (e-mail address removed)
thanks zibby1199
Database Connection File
------------------------------------------------------------------------------------------------------------------------------------------
<%@ LANGUAGE="JAVASCRIPT" %>
<%
myconn=Server.CreateObject("ADODB.connection");
mydb = "Driver={Microsoft Access Driver
(*.mdb)};DBQ=c:\\onlinedata\\webs\\PhoneUnlockers.net\\test\\BizOpps\\BizOpps.mdb";
myconn.Open (mydb);
rs = Server.CreateObject("ADODB.Recordset");
%>
------------------------------------------------------------------------------------------------------------------------------------------
Display Page
------------------------------------------------------------------------------------------------------------------------------------------
<%
sql = "Select * from tblUser" ;
rs=myconn.Execute(sql);
while (!rs.eof)
{
%>
Name: <%=rs("Name")%>,
DOB: <%=rs("DOB")%>,
Address: <%=rs("Address")%>
<%
rs.movenext();
}
rs.Close();
%>
------------------------------------------------------------------------------------------------------------------------------------------