Asp Javascript language paging larger database record sets

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();
%>
------------------------------------------------------------------------------------------------------------------------------------------
 
M

McKirahan

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?????????????????????????

[snip]

URL:http://databases.aspfaq.com/database/how-do-i-page-through-a-recordset.h
tml
 
E

Evertjan.

zibby1199 wrote on 30 Sep 2006 in microsoft.public.inetserver.asp.general:
that url does not work

thanks for the reply though.

Where are you posting about?

[please always quote on usenet]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,995
Messages
2,570,236
Members
46,822
Latest member
israfaceZa

Latest Threads

Top