Asp Javascript language paging larger database record sets

Discussion in 'ASP General' started by zfarooq01@hotmail.com, Sep 29, 2006.

  1. Guest

    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
    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, 2006
    #1
    1. Advertisements

  2. McKirahan Guest

    <> wrote in message
    news:...
    > 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
     
    McKirahan, Sep 29, 2006
    #2
    1. Advertisements

  3. zibby1199 Guest

    that url does not work

    thanks for the reply though.
     
    zibby1199, Sep 30, 2006
    #3
  4. Evertjan. Guest

    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)
     
    Evertjan., Sep 30, 2006
    #4
  5. McKirahan Guest

    McKirahan, Sep 30, 2006
    #5
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Steven K

    Record Paging

    Steven K, Jun 16, 2004, in forum: ASP .Net
    Replies:
    2
    Views:
    487
    news.microsoft.com
    Jun 17, 2004
  2. =?Utf-8?B?UGF0cmljay5PLklnZQ==?=

    DataSet paging vs Datareader paging

    =?Utf-8?B?UGF0cmljay5PLklnZQ==?=, Oct 8, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    11,390
    Scott Allen
    Oct 8, 2004
  3. wh1974
    Replies:
    0
    Views:
    2,740
    wh1974
    Jan 12, 2005
  4. Red
    Replies:
    1
    Views:
    919
  5. Peter Williams
    Replies:
    1
    Views:
    1,870
    Dylan Parry
    Jun 3, 2005
  6. Andrew James
    Replies:
    1
    Views:
    295
    Dieter Maurer
    Nov 20, 2004
  7. Mike N.
    Replies:
    0
    Views:
    711
    Mike N.
    Jul 31, 2008
  8. Shahid Juma

    Record Sets

    Shahid Juma, Jan 26, 2005, in forum: ASP General
    Replies:
    3
    Views:
    184
    Shahid Juma
    Jan 27, 2005
Loading...