469,902 Members | 1,976 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,902 developers. It's quick & easy.

Asp Javascript language paging larger database record sets

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*******@hotmail.com
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();
%>
------------------------------------------------------------------------------------------------------------------------------------------

Sep 29 '06 #1
4 2087
<zf*******@hotmail.comwrote in message
news:11*********************@m73g2000cwd.googlegro ups.com...
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...-a-recordset.h
tml
Sep 29 '06 #2
that url does not work

thanks for the reply though.

Sep 30 '06 #3
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]

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
Sep 30 '06 #4
"zibby1199" <zf*******@hotmail.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...
that url does not work

thanks for the reply though.
The "tml" at the end was on the next line.

http://databases.aspfaq.com/database...recordset.html
Sep 30 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Luiz Antonio Gomes Pican?o | last post: by
5 posts views Thread by aaronwmail-usenet | last post: by
8 posts views Thread by AG | last post: by
5 posts views Thread by Donald Adams | last post: by
8 posts views Thread by Donald Adams | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.