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 Post Reply

2294

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 turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

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

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server