Separate Pagewise - ASP / Active Server Pages

I am using ASP and Ms Access. To view the details from table. I have added more than 25 records. so i want to separate the pagewise. First page i want display the 10 record. Next page next 10. plz help me for this coding.

Feb 27 '08 #1

Subscribe Reply

2295

CroCrew

564

Expert 512MB

Hello silvia21,

Here is an example that you can use. Let me know if you need a copy of an example database that this will work with. The page is called Example.asp

Hope this helps~

Example.asp

Expand|Select|Wrap|Line Numbers

 
<%

    NumberOfRecordsPerPage = 3
 
    Function GetPageNumber()

        Select Case Request("xAction")

            Case "Beginning"

                GetPageNumber = 1

            Case "Previous"

                GetPageNumber = Request("intpage") - 1

                If (GetPageNumber < 1) Then 

                    GetPageNumber = 1

                End If

            Case "Next"

                GetPageNumber = Request("intpage") + 1

                If (GetPageNumber > intPageCount) Then

                    GetPageNumber = IntPageCount

                End If

            Case "Last"

                GetPageNumber = intPageCount

            Case Else

                GetPageNumber = 1

        End Select 

    End Function
 
    SQL = "SELECT FieldOne, FieldTwo, FieldThree FROM TheTable"
 
    Set Conn = Server.CreateObject("ADODB.Connection")

        Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Database/Database.mdb") 

        Set rsList = Server.CreateObject("ADODB.Recordset")

            rsList.CursorType = 1

            rsList.LockType = 3

            rsList.Open SQL, Conn

            rsList.PageSize = NumberOfRecordsPerPage 
 
        intPageCount = rsList.PageCount

        intpage = GetPageNumber()

        rsList.AbsolutePage = intPage

%>

<html>

    <head>

        <title>Example</title>

        <script language="JavaScript">

            function MoveTopage(xAction)

            {

                document.PageMove.xAction.value=xAction;

                document.PageMove.submit();

            }

        </script >

    </head>

    <body>

        <table width="600">

            <tr>

                <td>

                    <table width="100%">

                        <tr>

                            <td>Field One</td>

                            <td>Field Two</td>

                            <td>Field Three</td>

                        </tr>

                        <%For intRecord = 1 To rsList.PageSize%>

                            <tr>

                                <td><%=rsList("FieldOne").value%></td>

                                <td><%=rsList("FieldTwo").value%></td>

                                <td><%=rsList("FieldThree").value%></td>

                            </tr>

                            <%response.flush%>

                            <%rsList.MoveNext%>

                            <%If rsList.EOF Then Exit For%>

                        <%Next%>

                    </table>

                </td>

            </tr>

            <tr>

                <td align="center">

                    <input type="button" value=" &lt;&lt; " onclick="MoveTopage('Beginning');">

                    <input type="button" value=" &lt; " onclick="MoveTopage('Previous');">

                    <input type="button" value=" &gt; " onclick="MoveTopage('Next');">

                    <input type="button" value=" &gt;&gt; " onclick="MoveTopage('Last');">

                    <br>Page: <%=Intpage & " of " & intpagecount%>

                </td>

            </tr>

        </table>

        <form name="PageMove" action="Example.asp" method="post">

            <input type="hidden" name="xAction" value="">

            <input type="hidden" name="intpage" value="<%=intpage%>">

        </form>

    </body>

</html>

Feb 27 '08 #2

Similar topics

How to separate this string

by: Roberto Becerril | last post by:

Hi forum, i'm a little new in javascript and maybe you can help me. I have an html form and an icon, if i click on the icon, a new pop-up window is open and shows a list of numbers with a...

Javascript

Separate DAC from BO logic? What about physical assembly?

by: Mike Hennessy | last post by:

I'm looking for people's opinions and feedback regarding the design of the application tier, and how to best logically separate out the Data Access from the Business Object's. Per the Microsoft...

.NET Framework

plone site in separate database - MountFolder

by: krzychu | last post by:

Hallo, I have an existing plone site called "info", I've added some scripts to it. I would like to have that plone site into a separate ZODB database(separate ..fs file). There is a MountFolder...

Python

Want to keep deleted records in a separate table. How?

by: Scott Kinney | last post by:

I have an inventory database. I want to delete out-of-stock items from the main database, but keep them in a separate table so that I can reference data about them. I created a copy of the item...

Microsoft Access / VBA

Loading plugins in separate AppDomains

by: Pete Davis | last post by:

I'm confused about what precisely the limitations are on loading plugins in separate app domains. In all my previous apps that supported plugins, I've loaded them into the same domain as the app,...

C# / C Sharp

Separate Webserver and SQL Server -- error when connecting asp.netapp to a database

by: Ann Marinas | last post by:

Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed...

ASP.NET

When to make separate databases?

by: LurfysMa | last post by:

I would like to hear opinions on the tradeoffs of putting the tables, forms, and queries for several related datasets in separate databases vs one combined database. I am working on an...

Microsoft Access / VBA

Slabwise & Pagewise Datareport

by: Neelesh2007 | last post by:

Hi all. In my project I am using VB6.0 & Access 2003. I want to create Slab wise & Pagewise Datareport as shown below. Marks <30 ID Subject Marks 11 Maths 25 75 ...

Visual Basic 4 / 5 / 6

progress bar from a separate thread in netbeans

by: Silgd1 | last post by:

Hi All..... I am using netbeans 6.1 to create a web application(visual web jsf pages). I have a heavy task I need to run, so I run the task in a separate thread which is started from a...

Java

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp