Link to home
Start Free TrialLog in
Avatar of awilderbeast
awilderbeastFlag for United Kingdom of Great Britain and Northern Ireland

asked on

jquery paging/searching script seems to be hiding(all/parts) of my edit rows (.net listview)

hi all

script here
$(document).ready(function () {
    $('#txtUserSearch').keyup(function () {
        searchTable($(this).val(), '#MainContent_lvUsers_tblUserList');
    });
    $('#txtUserItemSearch').keyup(function () {
        searchTable($(this).val(), '#tblUserItems');
    });
    $('#txtMicrosoftSearch').keyup(function () {
        searchTable($(this).val(), '#MainContent_ListView1_tblMicrosoft');
    });
    $('#txtEquipmentSearch').keyup(function () {
        searchTable($(this).val(), '#tblEquipment');
    });

    paginate();
});

function paginate() {
    $('table.gridview').each(function () {
        var currentPage = 0;
        var numPerPage = 20;
        var $table = $(this);
        $table.bind('repaginate', function () {
            $table.find('tbody tr:not(.exclude)').hide().slice(currentPage * numPerPage, (currentPage + 1) * numPerPage).show();
        });
        $table.trigger('repaginate');
        var numRows = $table.find('tbody tr:not(.exclude)').length;
        var numPages = Math.ceil(numRows / numPerPage);
        var $pager = $('<div id="pager" class="pager"></div>');
        for (var page = 0; page < numPages; page++) {
            $('<span class="page-number"></span>').text(page + 1).bind('click', {
                newPage: page
            }, function (event) {
                currentPage = event.data['newPage'];
                $table.trigger('repaginate');
                $(this).addClass('active').siblings().removeClass('active');
            }).appendTo($pager).addClass('clickable');
        }
        // Clear the old pager first
        $('#pager').remove();
        $pager.insertBefore($table).find('span.page-number:first').addClass('active');
    });
}

function searchTable(inputVal, tablename) {
    var table = $(tablename);
        table.find('tr:not(.header)').each(function (index, row) {
        var allCells = $(row).find('td');
        if (allCells.length > 0) {
            var found = false;
            allCells.each(function (index, td) {
                var regExp = new RegExp(inputVal, 'i');
                if (regExp.test($(td).text())) {
                    found = true;
                    return false;
                }
            });
            if (found == true) $(row).show().removeClass('exclude'); else $(row).hide().addClass('exclude');
        }
    });
    paginate();
}

Open in new window


problems here
his jquery is used on a asp.net listview and when i press edit another row is added with a large table for editing inside, now if the table is towards the bottom of the pager, not all, infact barley any of the edit row form is displayed

see pics
top edit  - the full form is visible
User generated image
bottom edit - two or three lines visisble
User generated image
if i try and edit the the record at the very bottom, i get no visible form...

i think whats happening is the jquery is being added to the subtable inside my row.

below is the code in edit mode (snippet anyway)
can we make the script ignore that row, or will it work if we ignore class details and beyond? im thinking that row has to be ignored?

<tr>
                <td class="edit" colspan="8">
                    <div class="details">
                        <asp:HiddenField ID="hidID" runat="server" Value='<%# Bind("ID") %>' />
                        <asp:HiddenField ID="hidUserID" runat="server" Value='<%# Bind("UserID") %>' ClientIDMode="Static" />  
                        <table class="detailsview" cellpadding="0" cellspacing="0">
                            <tr>
                                <td class="td_title_align">Name:</td>
                                <td>
                                    <asp:TextBox ID="txtName" runat="server" Text='<%# Bind("Name") %>' CssClass="edit_box"></asp:TextBox>

Open in new window


Thanks
Avatar of Julian Hansen
Julian Hansen
Flag of South Africa image

If I understand the problem correctly then all you need to do is modify your JQuery to work on tables / rows that do not have a particular class and then give the table / row you want to ignore that class.

Other than that without seeing the app it is difficult to envisage the problem. For instance why is the container not expanding to incorporate the expanded row or showing scrollbars.

Maybe a solution is to make sure the container does not have overflow: hidden.
Avatar of awilderbeast

ASKER

yeah thats what i though, how do i do that, if i add a class of say "no_page" to the row

what do you mean the container not expading or showing scroll bars?

id show you the app but its an hosted only on my laptop

there is no overflow:hidden in any of my code

Thanks
hi there,

any update on this?

Thanks
hello,

could you tell me how to exlude a row from the pagination and have it be displayed?

i think its something in these lines that needs adding but i dont know what...

$table.bind('repaginate', function () {
            $table.find('tbody tr:not(.exclude)').hide().slice(currentPage * numPerPage, (currentPage + 1) * numPerPage).show();
        });

Open in new window


thanks
Sorry missed your earlier posts. Trying to reload the problem.

Basically give the rows you want to exclude the class exclude - that should do it.

i.e.

<tr class="exclude">
...
it didnt work

Heres a sample, ive put  a table in a row with BIG TABLE all over it
iv added my styles to it too so you can see it properly

what ive just found is happening, is the other half of the "BIG TABLE" is getting pushed to page 2 of the paging, you can see in the demo, the other half of the BIG TABLE is on paging 2

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title></title>
    <style type="text/css">
        .gridview {
    width: 100%;
    display: table;
    padding: 5px;
    margin: 0;
}
.gridview tr.header,.gridview thead tr {
    font-weight: bold;
    color: #fff;
    background-color: #1296bc;
    /*background-image: url('/content/images/table_header_bg.png');*/
    background-repeat: repeat-x;
    text-align: left;
    height: 21px;
    padding: 0;
    padding-bottom: 4px;
}
.calendar, .calendar .ajax__calendar_container {
    border:1px solid #646464;
    background-color: white;
    color: black;
}
.detailsview .calendar tr td, .detailsview .calendar tr {
    margin:0;
    padding:0;
    height:auto;
    width:auto
}

.head_link, .head_link a, .head_link img {
text-decoration: none;
color: #fff;
border: none;
vertical-align: middle;
}
.even, .odd {
border-bottom:1px solid #CCC;
}
.even{
   background-color: #FFF; 
}
.odd {
    background-color: #E2E4FF; 
}
.edit {
    padding: 0;
    margin: 0;
}
.details {
    background-color:#f8f8f8;
    padding: 5px;
}
.detailsview {
    
    display: table;
    margin: 0;   
}
.detailsview tr {
        height: 38px;
    }
.detailsview tr td {
        padding: 0 5px;
    }
.td_title_align {
    text-align: right;
}
.footer_command {
    padding: 5px;
    display: block;
    text-align: right;
}

.search_button {
    margin-left:-107px;
}
.search_box {
    width: 250px;
    padding:6px 95px 6px 6px;
}
.edit_box {
    padding:6px 95px 6px 6px;
}

input, select {
    vertical-align:middle;
    -moz-border-radius:4px; 
    -webkit-border-radius:4px;}
input[type="text"], select {
    background:#FFF;
    border:1px solid #bbb;
}
input[type="submit"] {
    width:100px; 
    font-weight: bold;
    padding:2px; border:none; 
    color:#fff; 
    background: #1296bc; 
    text-shadow:0px -1px 2px rgba(0,0,0,.7);
    cursor:pointer;-moz-border-radius:2px; 
    -webkit-border-radius:2px;
}
input[type="submit"]::-moz-focus-inner {
    border:0;
}
input[type="submit"]:focus {
    background:#333;
}

.search {
    float:right; 
    font-weight: bold; 
    height: 25px;
}
.search input {
        width: 200px;
}
    
/* PAGING*/
div.pager {
float: left;
margin-bottom: 10px;
}

div.pager span {
    display: inline-block;
    padding: 5px;
    text-align: center;
    cursor: pointer;
    background: #E2E4FF;
    color: #000;
    margin-right: 0.5em;
}

div.pager span.active {
    background: #1296bc;
    color: #FFF
}

.insert_button {
    padding: 5px;
    cursor: pointer;
    background: #E2E4FF;
    color: #000;
}

/* COLOR SCALES*/
.green {
    background-color:#61c644;
    color:#335534;
}
.orange {
    background-color:#e69625;
    color:#cf1616;
}
.red {
    background-color:#c12121;
    color:#FFF;
}
    </style>
    <script type="text/javascript" src="Scripts/jquery-1.6.2.js"></script>
    <script type="text/javascript">
        $(document).ready(function () {
            $('#txtUserSearch').keyup(function () {
                searchTable($(this).val(), '#MainContent_lvUsers_tblUserList');
            });
            $('#txtUserItemSearch').keyup(function () {
                searchTable($(this).val(), '#tblUserItems');
            });
            $('#txtMicrosoftSearch').keyup(function () {
                searchTable($(this).val(), '#MainContent_ListView1_tblMicrosoft');
            });
            $('#txtEquipmentSearch').keyup(function () {
                searchTable($(this).val(), '#tblEquipment');
            });

            paginate();
        });

        function paginate() {
            $('table.gridview').each(function () {
                var currentPage = 0;
                var numPerPage = 20;
                var $table = $(this);
                $table.bind('repaginate', function () {
                    $table.find('tbody tr:not(.exclude)').hide().slice(currentPage * numPerPage, (currentPage + 1) * numPerPage).show();
                });
                $table.trigger('repaginate');
                var numRows = $table.find('tbody tr:not(.exclude)').length;
                var numPages = Math.ceil(numRows / numPerPage);
                var $pager = $('<div id="pager" class="pager"></div>');
                for (var page = 0; page < numPages; page++) {
                    $('<span class="page-number"></span>').text(page + 1).bind('click', {
                        newPage: page
                    }, function (event) {
                        currentPage = event.data['newPage'];
                        $table.trigger('repaginate');
                        $(this).addClass('active').siblings().removeClass('active');
                    }).appendTo($pager).addClass('clickable');
                }
                // Clear the old pager first
                $('#pager').remove();
                $pager.insertBefore($table).find('span.page-number:first').addClass('active');
            });
        }

        function searchTable(inputVal, tablename) {
            var table = $(tablename);
            table.find('tr:not(.header)').each(function (index, row) {
                var allCells = $(row).find('td');
                if (allCells.length > 0) {
                    var found = false;
                    allCells.each(function (index, td) {
                        var regExp = new RegExp(inputVal, 'i');
                        if (regExp.test($(td).text())) {
                            found = true;
                            return false;
                        }
                    });
                    if (found == true) $(row).show().removeClass('exclude'); else $(row).hide().addClass('exclude');
                }
            });
            paginate();
        }

    </script>
</head>
<body>
<div class="search" >Search: <input type="text" id="txtEquipmentSearch"/></div>
<table cellpadding="0" cellspacing="0" class="gridview" ID="tblEquipment">
                <thead>
                    <tr class="header">
                        <th>Name</th>
                        <th>Email</th>
                        <th>City</th>
                        <th>Country</th>
                    </tr>
                </thead>
    <tbody>
        <tr>
            <td>Wade</td>
            <td>vitae.orci.Phasellus@Morbisit.org</td>
            <td>Kemmerer</td>
            <td>Benin</td>
        </tr>
        <tr>
            <td>Leroy</td>
            <td>enim.Suspendisse@Maecenas.com</td>
            <td>Alamogordo</td>
            <td>Denmark</td>
        </tr>
        <tr>
            <td>Magee</td>
            <td>ultricies.adipiscing.enim@nullaCras.org</td>
            <td>Palmdale</td>
            <td>Burkina Faso</td>
        </tr>
        <tr>
            <td>Quamar</td>
            <td>parturient@Fuscedolor.ca</td>
            <td>South Portland</td>
            <td>Yemen</td>
        </tr>
        <tr>
            <td>Sebastian</td>
            <td>velit.Quisque.varius@Suspendisse.ca</td>
            <td>Durant</td>
            <td>Ethiopia</td>
        </tr>
        <tr>
            <td>Gary</td>
            <td>Curabitur.egestas@Nulla.org</td>
            <td>Mesquite</td>
            <td>Greenland</td>
        </tr>
        <tr>
            <td>Macon</td>
            <td>Aenean@etmalesuadafames.edu</td>
            <td>Paramount</td>
            <td>Tuvalu</td>
        </tr>
        <tr>
            <td>Axel</td>
            <td>magna@commodoatlibero.com</td>
            <td>Albany</td>
            <td>Faroe Islands</td>
        </tr>
        <tr>
            <td>Neville</td>
            <td>Donec.non@dictumProin.edu</td>
            <td>Richmond</td>
            <td>Guinea</td>
        </tr>
        <tr>
            <td>Lamar</td>
            <td>netus.et@Phasellusataugue.ca</td>
            <td>Placentia</td>
            <td>Spain</td>
        </tr>
        <tr>
            <td>Barrett</td>
            <td>magnis@auctor.edu</td>
            <td>Bellflower</td>
            <td>Ethiopia</td>
        </tr>
        <tr>
            <td>Daquan</td>
            <td>arcu@sed.edu</td>
            <td>Keene</td>
            <td>China</td>
        </tr>
        <tr>
            <td>Kennan</td>
            <td>magna@nonduinec.com</td>
            <td>Barre</td>
            <td>South Georgia and The South Sandwich Islands</td>
        </tr>
        <tr>
            <td>Wing</td>
            <td>eu@metus.com</td>
            <td>White Plains</td>
            <td>Bouvet Island</td>
        </tr>
        <tr>
            <td>Elijah</td>
            <td>tincidunt.tempus@commodoauctor.com</td>
            <td>Sandy</td>
            <td>Uruguay</td>
        </tr>
        <tr>
            <td>Jackson</td>
            <td>dui.Cras.pellentesque@InloremDonec.org</td>
            <td>Centennial</td>
            <td>Indonesia</td>
        </tr>
        <tr>
            <td>Lane</td>
            <td>nunc.est.mollis@nequeNullamut.edu</td>
            <td>Ogdensburg</td>
            <td>Argentina</td>
        </tr>
        <tr>
            <td>Devin</td>
            <td>dictum@enim.edu</td>
            <td>Kearns</td>
            <td>Switzerland</td>
        </tr>
        <tr class="exclude">
            <td colspan="4">
                <table>
                    <tr>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                    </tr>
                    <tr>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                    </tr>
                    <tr>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                    </tr>
                    <tr>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                    </tr>
                    <tr>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                    </tr>
                    <tr>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                    </tr>
                    <tr>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                        <td>TEST BIG TABLE inside row</td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr>
            <td>Logan</td>
            <td>dignissim.Maecenas.ornare@egestas.edu</td>
            <td>Eureka</td>
            <td>Mayotte</td>
        </tr>
        <tr>
            <td>Zane</td>
            <td>Sed.eu@Suspendissenonleo.org</td>
            <td>Duarte</td>
            <td>Martinique</td>
        </tr>
        <tr>
            <td>Gregory</td>
            <td>Maecenas.ornare@risusDonec.edu</td>
            <td>Manassas</td>
            <td>Sierra Leone</td>
        </tr>
        <tr>
            <td>Dennis</td>
            <td>odio.Aliquam.vulputate@turpisegestasAliquam.org</td>
            <td>Palos Verdes Estates</td>
            <td>Lesotho</td>
        </tr>
        <tr>
            <td>Dennis</td>
            <td>eu@ametdiam.edu</td>
            <td>Vail</td>
            <td>Czech Republic</td>
        </tr>
        <tr>
            <td>Isaac</td>
            <td>facilisis.vitae@metussit.com</td>
            <td>Winooski</td>
            <td>Mali</td>
        </tr>
        <tr>
            <td>Lucius</td>
            <td>Cras.convallis@aliquet.org</td>
            <td>Webster Groves</td>
            <td>Palau</td>
        </tr>
        <tr>
            <td>Damon</td>
            <td>ac@dui.edu</td>
            <td>Nampa</td>
            <td>Trinidad and Tobago</td>
        </tr>
        <tr>
            <td>Colorado</td>
            <td>luctus.ut@dapibusid.edu</td>
            <td>Philadelphia</td>
            <td>Zimbabwe</td>
        </tr>
        <tr>
            <td>Lawrence</td>
            <td>sed.est.Nunc@mollisPhaselluslibero.com</td>
            <td>Evansville</td>
            <td>Peru</td>
        </tr>
        <tr>
            <td>Philip</td>
            <td>turpis@Nullam.ca</td>
            <td>Signal Hill</td>
            <td>Bosnia and Herzegovina</td>
        </tr>
        <tr>
            <td>Solomon</td>
            <td>urna@felispurus.ca</td>
            <td>Highland Park</td>
            <td>Reunion</td>
        </tr>
        <tr>
            <td>Craig</td>
            <td>felis.Nulla@lacusQuisqueimperdiet.ca</td>
            <td>Richmond</td>
            <td>Iran, Islamic Republic of</td>
        </tr>
        <tr>
            <td>Lucas</td>
            <td>vitae@nonhendreritid.com</td>
            <td>Holyoke</td>
            <td>Greenland</td>
        </tr>
        <tr>
            <td>Orlando</td>
            <td>sit@Nuncpulvinar.com</td>
            <td>Ponce</td>
            <td>Turkey</td>
        </tr>
        <tr>
            <td>Martin</td>
            <td>Nulla.aliquet.Proin@erat.ca</td>
            <td>Toledo</td>
            <td>Zambia</td>
        </tr>
        <tr>
            <td>Hakeem</td>
            <td>elit@auctor.com</td>
            <td>North Platte</td>
            <td>Nepal</td>
        </tr>
        <tr>
            <td>Mason</td>
            <td>ultrices.a.auctor@diam.org</td>
            <td>Nampa</td>
            <td>Wallis and Futuna</td>
        </tr>
        <tr>
            <td>Vladimir</td>
            <td>ante@Craseutellus.com</td>
            <td>Trenton</td>
            <td>Brazil</td>
        </tr>
        <tr>
            <td>Colin</td>
            <td>auctor@mollisIntegertincidunt.edu</td>
            <td>Williamsburg</td>
            <td>Liechtenstein</td>
        </tr>
        <tr>
            <td>Dean</td>
            <td>arcu.Vestibulum.ante@dui.com</td>
            <td>Starkville</td>
            <td>Tonga</td>
        </tr>
        <tr>
            <td>Calvin</td>
            <td>luctus@metusAliquam.org</td>
            <td>Hilo</td>
            <td>South Africa</td>
        </tr>
        <tr>
            <td>Silas</td>
            <td>elit.fermentum.risus@litora.org</td>
            <td>Johnson City</td>
            <td>Lesotho</td>
        </tr>
        <tr>
            <td>Abdul</td>
            <td>Fusce.aliquam.enim@neque.com</td>
            <td>Moreno Valley</td>
            <td>China</td>
        </tr>
        <tr>
            <td>Callum</td>
            <td>risus@penatibuset.com</td>
            <td>Evanston</td>
            <td>Svalbard and Jan Mayen</td>
        </tr>
        <tr>
            <td>Howard</td>
            <td>placerat.augue@ataugue.org</td>
            <td>Chelsea</td>
            <td>Antigua and Barbuda</td>
        </tr>
        <tr>
            <td>Lawrence</td>
            <td>Nullam.velit.dui@Curabiturvellectus.ca</td>
            <td>Hammond</td>
            <td>Palestinian Territory, Occupied</td>
        </tr>
        <tr>
            <td>Jacob</td>
            <td>interdum.feugiat.Sed@Donecegestas.com</td>
            <td>Murrieta</td>
            <td>Japan</td>
        </tr>
        <tr>
            <td>Malik</td>
            <td>porta@sociisnatoque.edu</td>
            <td>College Station</td>
            <td>Sierra Leone</td>
        </tr>
        <tr>
            <td>Jonas</td>
            <td>sagittis.semper@aliquamarcuAliquam.com</td>
            <td>Revere</td>
            <td>Paraguay</td>
        </tr>
        <tr>
            <td>Damian</td>
            <td>non@magnamalesuadavel.ca</td>
            <td>Nenana</td>
            <td>Guatemala</td>
        </tr>
        <tr>
            <td>Phillip</td>
            <td>fermentum.convallis@arcu.com</td>
            <td>Lawton</td>
            <td>Heard Island and Mcdonald Islands</td>
        </tr>
        <tr>
            <td>George</td>
            <td>arcu@lectusquismassa.ca</td>
            <td>Lubbock</td>
            <td>Venezuela</td>
        </tr>
        <tr>
            <td>Ezra</td>
            <td>lectus.Cum@vulputateposuere.com</td>
            <td>Butler</td>
            <td>Cocos (Keeling) Islands</td>
        </tr>
        <tr>
            <td>Jason</td>
            <td>Nam.consequat.dolor@malesuadavel.org</td>
            <td>Rancho Palos Verdes</td>
            <td>Hong Kong</td>
        </tr>
        <tr>
            <td>Berk</td>
            <td>Donec.felis@eratvolutpatNulla.ca</td>
            <td>Cypress</td>
            <td>Estonia</td>
        </tr>
        <tr>
            <td>Damon</td>
            <td>laoreet.posuere.enim@Pellentesquehabitantmorbi.org</td>
            <td>Northampton</td>
            <td>Cocos (Keeling) Islands</td>
        </tr>
        <tr>
            <td>Cain</td>
            <td>tellus@metus.org</td>
            <td>Fajardo</td>
            <td>Egypt</td>
        </tr>
        <tr>
            <td>Hashim</td>
            <td>venenatis.vel@dictum.com</td>
            <td>La Palma</td>
            <td>Djibouti</td>
        </tr>
        <tr>
            <td>Stewart</td>
            <td>et.netus.et@nequenonquam.com</td>
            <td>Alpharetta</td>
            <td>Bermuda</td>
        </tr>
        <tr>
            <td>Clinton</td>
            <td>Lorem@parturient.com</td>
            <td>Eau Claire</td>
            <td>Palestinian Territory, Occupied</td>
        </tr>
        <tr>
            <td>Oscar</td>
            <td>luctus.aliquet.odio@venenatisvel.edu</td>
            <td>Reno</td>
            <td>Bahrain</td>
        </tr>
        <tr>
            <td>Howard</td>
            <td>massa.Integer@pedeblandit.org</td>
            <td>Sioux Falls</td>
            <td>Namibia</td>
        </tr>
        <tr>
            <td>Jason</td>
            <td>risus.Morbi.metus@eueleifend.com</td>
            <td>Kingston</td>
            <td>Hungary</td>
        </tr>
        <tr>
            <td>Gannon</td>
            <td>accumsan@anteblanditviverra.org</td>
            <td>Montpelier</td>
            <td>India</td>
        </tr>
        <tr>
            <td>Knox</td>
            <td>ipsum.Curabitur@vehicula.org</td>
            <td>Flagstaff</td>
            <td>Thailand</td>
        </tr>
        <tr>
            <td>Adrian</td>
            <td>lobortis.mauris@egetmetuseu.com</td>
            <td>Half Moon Bay</td>
            <td>Malta</td>
        </tr>
        <tr>
            <td>Cole</td>
            <td>sit.amet.luctus@nisiAenean.com</td>
            <td>Santa Cruz</td>
            <td>Korea, Republic of</td>
        </tr>
        <tr>
            <td>Kibo</td>
            <td>nisi@Fusce.ca</td>
            <td>Opelousas</td>
            <td>Monaco</td>
        </tr>
        <tr>
            <td>Dustin</td>
            <td>risus.at@Inmipede.edu</td>
            <td>Nashville</td>
            <td>Cuba</td>
        </tr>
        <tr>
            <td>Joseph</td>
            <td>nec@faucibuslectus.com</td>
            <td>Burbank</td>
            <td>New Caledonia</td>
        </tr>
        <tr>
            <td>Aquila</td>
            <td>rutrum@erat.ca</td>
            <td>New Bedford</td>
            <td>Viet Nam</td>
        </tr>
        <tr>
            <td>Blaze</td>
            <td>Fusce.fermentum.fermentum@vulputate.ca</td>
            <td>Paramount</td>
            <td>Dominican Republic</td>
        </tr>
        <tr>
            <td>Hector</td>
            <td>ut.mi@Uttincidunt.org</td>
            <td>Sunbury</td>
            <td>Brunei Darussalam</td>
        </tr>
        <tr>
            <td>Mannix</td>
            <td>ac.orci.Ut@Nulla.ca</td>
            <td>Pine Bluff</td>
            <td>Dominica</td>
        </tr>
        <tr>
            <td>Sean</td>
            <td>varius.Nam.porttitor@mauris.ca</td>
            <td>Corinth</td>
            <td>Paraguay</td>
        </tr>
        <tr>
            <td>Yoshio</td>
            <td>tristique.pellentesque@nectellusNunc.com</td>
            <td>Chino Hills</td>
            <td>Saint Lucia</td>
        </tr>
        <tr>
            <td>Warren</td>
            <td>urna@urnaNunc.com</td>
            <td>Pass Christian</td>
            <td>Guyana</td>
        </tr>
        <tr>
            <td>Brenden</td>
            <td>felis.orci@urna.edu</td>
            <td>Mesquite</td>
            <td>Bahrain</td>
        </tr>
        <tr>
            <td>Tanek</td>
            <td>justo.eu.arcu@ipsumSuspendisse.com</td>
            <td>Cheyenne</td>
            <td>Uganda</td>
        </tr>
        <tr>
            <td>Tucker</td>
            <td>non.quam.Pellentesque@Integer.edu</td>
            <td>Williston</td>
            <td>Guyana</td>
        </tr>
        <tr>
            <td>Burke</td>
            <td>ornare.lectus@fermentummetusAenean.org</td>
            <td>Dodge City</td>
            <td>Serbia and Montenegro</td>
        </tr>
        <tr>
            <td>Abbot</td>
            <td>amet.risus.Donec@felis.org</td>
            <td>Fitchburg</td>
            <td>Pitcairn</td>
        </tr>
        <tr>
            <td>Kuame</td>
            <td>aliquet.vel@necorci.com</td>
            <td>La Puente</td>
            <td>Albania</td>
        </tr>
        <tr>
            <td>Denton</td>
            <td>et@adipiscingligulaAenean.edu</td>
            <td>Bellflower</td>
            <td>Korea, Republic of</td>
        </tr>
        <tr>
            <td>Kermit</td>
            <td>penatibus.et.magnis@non.org</td>
            <td>Ardmore</td>
            <td>Nauru</td>
        </tr>
        <tr>
            <td>Cruz</td>
            <td>lorem@dolor.edu</td>
            <td>Saint Cloud</td>
            <td>Haiti</td>
        </tr>
        <tr>
            <td>Nolan</td>
            <td>gravida.Aliquam.tincidunt@egestasDuisac.com</td>
            <td>Seward</td>
            <td>Mauritius</td>
        </tr>
        <tr>
            <td>Myles</td>
            <td>Class@taciti.com</td>
            <td>Lawndale</td>
            <td>Swaziland</td>
        </tr>
        <tr>
            <td>Emerson</td>
            <td>nibh.Quisque.nonummy@ligulaAliquamerat.edu</td>
            <td>Meriden</td>
            <td>Netherlands</td>
        </tr>
        <tr>
            <td>Dalton</td>
            <td>a.tortor@dis.com</td>
            <td>International Falls</td>
            <td>Dominican Republic</td>
        </tr>
        <tr>
            <td>Graiden</td>
            <td>habitant.morbi@atarcuVestibulum.ca</td>
            <td>Durango</td>
            <td>Iraq</td>
        </tr>
        <tr>
            <td>Vincent</td>
            <td>tempor.bibendum@augue.ca</td>
            <td>Bandera</td>
            <td>Central African Republic</td>
        </tr>
        <tr>
            <td>Oscar</td>
            <td>Proin@ut.org</td>
            <td>Reedsport</td>
            <td>Macedonia</td>
        </tr>
        <tr>
            <td>Anthony</td>
            <td>nec.mauris@pedeet.ca</td>
            <td>Seattle</td>
            <td>Finland</td>
        </tr>
        <tr>
            <td>Driscoll</td>
            <td>vestibulum.nec.euismod@luctus.edu</td>
            <td>Kettering</td>
            <td>Puerto Rico</td>
        </tr>
        <tr>
            <td>Oliver</td>
            <td>dapibus.gravida.Aliquam@egetvarius.ca</td>
            <td>Richmond</td>
            <td>Mexico</td>
        </tr>
        <tr>
            <td>Branden</td>
            <td>massa.lobortis.ultrices@Sedeu.com</td>
            <td>Tyler</td>
            <td>Mongolia</td>
        </tr>
        <tr>
            <td>Steel</td>
            <td>eu.nulla@nequeseddictum.ca</td>
            <td>Azusa</td>
            <td>Russian Federation</td>
        </tr>
        <tr>
            <td>Steven</td>
            <td>feugiat@tacitisociosqu.edu</td>
            <td>Guthrie</td>
            <td>Zimbabwe</td>
        </tr>
        <tr>
            <td>Blaze</td>
            <td>pretium@idrisusquis.com</td>
            <td>Longview</td>
            <td>Haiti</td>
        </tr>
        <tr>
            <td>Chaney</td>
            <td>tristique@iaculisquispede.org</td>
            <td>Fredericksburg</td>
            <td>Lithuania</td>
        </tr>
        <tr>
            <td>Bruno</td>
            <td>Class.aptent@elementumdui.com</td>
            <td>Fountain Valley</td>
            <td>Germany</td>
        </tr>
        <tr>
            <td>Erich</td>
            <td>vitae@nibhAliquam.com</td>
            <td>Naperville</td>
            <td>Hungary</td>
        </tr>
        <tr>
            <td>Lee</td>
            <td>libero@ametrisusDonec.ca</td>
            <td>East Hartford</td>
            <td>Philippines</td>
        </tr>
        <tr>
            <td>Amos</td>
            <td>lectus@DonecestNunc.org</td>
            <td>Corinth</td>
            <td>Suriname</td>
        </tr>
        <tr>
            <td>Clayton</td>
            <td>Suspendisse.eleifend@metusfacilisislorem.org</td>
            <td>Agat</td>
            <td>Bolivia</td>
        </tr>
        <tr>
            <td>Raja</td>
            <td>quis.urna.Nunc@non.com</td>
            <td>Las Cruces</td>
            <td>Uganda</td>
        </tr>
        <tr>
            <td>Jackson</td>
            <td>a.mi.fringilla@lorem.edu</td>
            <td>Plano</td>
            <td>Puerto Rico</td>
        </tr>
        <tr>
            <td>Arthur</td>
            <td>Suspendisse@sitametmetus.org</td>
            <td>Natchez</td>
            <td>Belgium</td>
        </tr>
        <tr>
            <td>Arsenio</td>
            <td>Nullam@pedeblanditcongue.ca</td>
            <td>Waterloo</td>
            <td>Malaysia</td>
        </tr>
        <tr>
            <td>Oliver</td>
            <td>non.ante@mi.edu</td>
            <td>Williamsburg</td>
            <td>Korea</td>
        </tr>
        <tr>
            <td>Tucker</td>
            <td>aliquam.enim.nec@eleifendegestas.edu</td>
            <td>Fort Worth</td>
            <td>Tokelau</td>
        </tr>
        <tr>
            <td>Dustin</td>
            <td>fermentum.metus.Aenean@penatibus.com</td>
            <td>Elizabeth City</td>
            <td>Honduras</td>
        </tr>
        <tr>
            <td>Denton</td>
            <td>primis@consectetuer.edu</td>
            <td>Merced</td>
            <td>Madagascar</td>
        </tr>
        <tr>
            <td>Rooney</td>
            <td>eros@lobortisClassaptent.org</td>
            <td>El Cerrito</td>
            <td>Chad</td>
        </tr>
        <tr>
            <td>Eaton</td>
            <td>nunc.interdum.feugiat@Curabitur.edu</td>
            <td>Ardmore</td>
            <td>Croatia</td>
        </tr>
        <tr>
            <td>Rahim</td>
            <td>ut.lacus.Nulla@Fusce.org</td>
            <td>Los Angeles</td>
            <td>Denmark</td>
        </tr>
        <tr>
            <td>Mohammad</td>
            <td>augue.Sed.molestie@enimCurabitur.ca</td>
            <td>Ypsilanti</td>
            <td>Russian Federation</td>
        </tr>
        <tr>
            <td>Xander</td>
            <td>vulputate.mauris@a.ca</td>
            <td>Idaho Falls</td>
            <td>Ireland</td>
        </tr>
        <tr>
            <td>Joel</td>
            <td>magna@necmollis.org</td>
            <td>Omaha</td>
            <td>Antigua and Barbuda</td>
        </tr>
        <tr>
            <td>Denton</td>
            <td>sem@ante.org</td>
            <td>Laconia</td>
            <td>Iran, Islamic Republic of</td>
        </tr>
        <tr>
            <td>Grady</td>
            <td>libero.lacus.varius@enim.ca</td>
            <td>Austin</td>
            <td>Libyan Arab Jamahiriya</td>
        </tr>
        <tr>
            <td>Herrod</td>
            <td>faucibus.orci@Aliquamerat.edu</td>
            <td>Yazoo City</td>
            <td>Turkey</td>
        </tr>
        <tr>
            <td>Dustin</td>
            <td>sodales.at@luctusipsum.edu</td>
            <td>Morrison</td>
            <td>Israel</td>
        </tr>
        <tr>
            <td>Armando</td>
            <td>lorem.fringilla.ornare@nequevitaesemper.edu</td>
            <td>Covina</td>
            <td>Slovenia</td>
        </tr>
        <tr>
            <td>Shad</td>
            <td>magna@Fuscefeugiat.edu</td>
            <td>Taylorsville</td>
            <td>Jamaica</td>
        </tr>
        <tr>
            <td>Oscar</td>
            <td>adipiscing.elit@elit.ca</td>
            <td>Artesia</td>
            <td>Austria</td>
        </tr>
        <tr>
            <td>Justin</td>
            <td>non.massa@placeratvelitQuisque.edu</td>
            <td>Camden</td>
            <td>Kazakhstan</td>
        </tr>
        <tr>
            <td>Vernon</td>
            <td>diam.eu.dolor@acmattis.com</td>
            <td>Champaign</td>
            <td>Senegal</td>
        </tr>
        <tr>
            <td>Joseph</td>
            <td>blandit@dictumeleifend.edu</td>
            <td>Westminster</td>
            <td>Chile</td>
        </tr>
        <tr>
            <td>Malcolm</td>
            <td>Quisque.porttitor.eros@aarcu.com</td>
            <td>La Mirada</td>
            <td>Macao</td>
        </tr>
        <tr>
            <td>Nicholas</td>
            <td>Nulla@vehicula.com</td>
            <td>Mequon</td>
            <td>Costa Rica</td>
        </tr>
        <tr>
            <td>Bruce</td>
            <td>malesuada.malesuada.Integer@Phasellus.org</td>
            <td>Spokane</td>
            <td>Sao Tome and Principe</td>
        </tr>
        <tr>
            <td>Xanthus</td>
            <td>arcu@malesuadafames.com</td>
            <td>Moraga</td>
            <td>Reunion</td>
        </tr>
        <tr>
            <td>Conan</td>
            <td>tempor.diam.dictum@Vestibulum.org</td>
            <td>Port Huron</td>
            <td>United States</td>
        </tr>
        <tr>
            <td>Marvin</td>
            <td>a.scelerisque.sed@sapienimperdietornare.org</td>
            <td>Chico</td>
            <td>Indonesia</td>
        </tr>
        <tr>
            <td>Gareth</td>
            <td>Ut.sagittis.lobortis@nequesed.com</td>
            <td>Hollywood</td>
            <td>Iceland</td>
        </tr>
        <tr>
            <td>Felix</td>
            <td>at.fringilla.purus@acfermentum.com</td>
            <td>Cedarburg</td>
            <td>Cocos (Keeling) Islands</td>
        </tr>
        <tr>
            <td>Devin</td>
            <td>Nullam@tinciduntnibh.edu</td>
            <td>Ketchikan</td>
            <td>Marshall Islands</td>
        </tr>
        <tr>
            <td>Alec</td>
            <td>purus.ac@nisi.org</td>
            <td>Port Huron</td>
            <td>Kuwait</td>
        </tr>
        <tr>
            <td>Garrett</td>
            <td>non@velnislQuisque.com</td>
            <td>Davenport</td>
            <td>Thailand</td>
        </tr>
        <tr>
            <td>Camden</td>
            <td>sit@lectus.com</td>
            <td>Fullerton</td>
            <td>Poland</td>
        </tr>
        <tr>
            <td>Noah</td>
            <td>urna.suscipit.nonummy@risusat.org</td>
            <td>Chandler</td>
            <td>Suriname</td>
        </tr>
        <tr>
            <td>Callum</td>
            <td>id.mollis@feugiat.ca</td>
            <td>Providence</td>
            <td>Peru</td>
        </tr>
        <tr>
            <td>Amir</td>
            <td>gravida.sit.amet@ornarelibero.org</td>
            <td>Ketchikan</td>
            <td>Kiribati</td>
        </tr>
        <tr>
            <td>Phelan</td>
            <td>consectetuer.cursus.et@felis.ca</td>
            <td>Truth or Consequences</td>
            <td>Turkmenistan</td>
        </tr>
        <tr>
            <td>Lane</td>
            <td>dapibus@eratvitae.org</td>
            <td>Edina</td>
            <td>Venezuela</td>
        </tr>
        <tr>
            <td>Dylan</td>
            <td>Sed.eget@Sedid.ca</td>
            <td>Gadsden</td>
            <td>French Guiana</td>
        </tr>
        <tr>
            <td>Palmer</td>
            <td>nibh.Phasellus.nulla@cursus.com</td>
            <td>Lodi</td>
            <td>Georgia</td>
        </tr>
        <tr>
            <td>Austin</td>
            <td>Cum@nisl.com</td>
            <td>Coatesville</td>
            <td>Myanmar</td>
        </tr>
        <tr>
            <td>Joshua</td>
            <td>massa.rutrum.magna@urnaNullam.com</td>
            <td>Fond du Lac</td>
            <td>Oman</td>
        </tr>
        <tr>
            <td>Merritt</td>
            <td>libero.at@auctorodioa.org</td>
            <td>Duncan</td>
            <td>Cook Islands</td>
        </tr>
        <tr>
            <td>Hashim</td>
            <td>molestie@eu.ca</td>
            <td>Gastonia</td>
            <td>Malaysia</td>
        </tr>
        <tr>
            <td>Sebastian</td>
            <td>a.mi.fringilla@litoratorquentper.ca</td>
            <td>Kettering</td>
            <td>Slovenia</td>
        </tr>
        <tr>
            <td>Marvin</td>
            <td>rhoncus.id@diam.com</td>
            <td>Pine Bluff</td>
            <td>Japan</td>
        </tr>
        <tr>
            <td>Wang</td>
            <td>feugiat.placerat.velit@magnatellus.org</td>
            <td>New Rochelle</td>
            <td>Argentina</td>
        </tr>
        <tr>
            <td>Paki</td>
            <td>sapien.Nunc.pulvinar@non.com</td>
            <td>Rancho Santa Margarita</td>
            <td>Lesotho</td>
        </tr>
        <tr>
            <td>Cody</td>
            <td>pharetra.Quisque@idblandit.ca</td>
            <td>Fargo</td>
            <td>Christmas Island</td>
        </tr>
        <tr>
            <td>Daquan</td>
            <td>Mauris.non@metus.ca</td>
            <td>Laconia</td>
            <td>Spain</td>
        </tr>
        <tr>
            <td>Todd</td>
            <td>amet.diam.eu@sagittislobortis.ca</td>
            <td>Meridian</td>
            <td>Denmark</td>
        </tr>
        <tr>
            <td>Oliver</td>
            <td>arcu.Curabitur@odioauctor.edu</td>
            <td>Staunton</td>
            <td>Cocos (Keeling) Islands</td>
        </tr>
        <tr>
            <td>Nehru</td>
            <td>penatibus@adipiscing.ca</td>
            <td>Independence</td>
            <td>Ecuador</td>
        </tr>
        <tr>
            <td>Giacomo</td>
            <td>tempus.risus@egestas.org</td>
            <td>Boston</td>
            <td>Kiribati</td>
        </tr>
        <tr>
            <td>Kirk</td>
            <td>mauris.ut@Phasellus.org</td>
            <td>Frankfort</td>
            <td>Ukraine</td>
        </tr>
        <tr>
            <td>Brandon</td>
            <td>nec.tellus.Nunc@Aliquam.edu</td>
            <td>Fargo</td>
            <td>New Caledonia</td>
        </tr>
        <tr>
            <td>Fuller</td>
            <td>turpis.egestas.Aliquam@porttitorvulputate.com</td>
            <td>New Britain</td>
            <td>Gibraltar</td>
        </tr>
        <tr>
            <td>Thaddeus</td>
            <td>tellus.justo.sit@Crasdolor.org</td>
            <td>Torrington</td>
            <td>Czech Republic</td>
        </tr>
        <tr>
            <td>Allen</td>
            <td>Nunc.lectus.pede@est.org</td>
            <td>Chicopee</td>
            <td>Macao</td>
        </tr>
        <tr>
            <td>Forrest</td>
            <td>non.massa@iaculis.ca</td>
            <td>Valdez</td>
            <td>Algeria</td>
        </tr>
        <tr>
            <td>Steven</td>
            <td>eleifend.vitae.erat@vehicularisusNulla.ca</td>
            <td>Cary</td>
            <td>Uganda</td>
        </tr>
        <tr>
            <td>Stone</td>
            <td>lorem.auctor.quis@faucibusut.com</td>
            <td>Redding</td>
            <td>Lesotho</td>
        </tr>
        <tr>
            <td>Brian</td>
            <td>congue@Donectempus.ca</td>
            <td>Attleboro</td>
            <td>Anguilla</td>
        </tr>
        <tr>
            <td>Ferris</td>
            <td>Duis.mi@mattisCraseget.edu</td>
            <td>Agat</td>
            <td>Ireland</td>
        </tr>
        <tr>
            <td>Aaron</td>
            <td>faucibus.orci@Vivamus.com</td>
            <td>West Sacramento</td>
            <td>Czech Republic</td>
        </tr>
        <tr>
            <td>Bradley</td>
            <td>In@euenim.com</td>
            <td>Baltimore</td>
            <td>Reunion</td>
        </tr>
        <tr>
            <td>Jesse</td>
            <td>pellentesque.eget.dictum@metus.com</td>
            <td>Dana Point</td>
            <td>Algeria</td>
        </tr>
        <tr>
            <td>Wade</td>
            <td>sed.tortor@Proindolor.edu</td>
            <td>Vicksburg</td>
            <td>Saint Vincent and The Grenadines</td>
        </tr>
        <tr>
            <td>Gareth</td>
            <td>sodales@velnislQuisque.ca</td>
            <td>Wheeling</td>
            <td>Niger</td>
        </tr>
        <tr>
            <td>Avram</td>
            <td>pede.nonummy.ut@utsemNulla.com</td>
            <td>Honolulu</td>
            <td>Portugal</td>
        </tr>
        <tr>
            <td>Alec</td>
            <td>sit.amet@interdumNuncsollicitudin.edu</td>
            <td>Pittsburgh</td>
            <td>Togo</td>
        </tr>
        <tr>
            <td>Luke</td>
            <td>nisl.Maecenas.malesuada@pharetraNam.com</td>
            <td>Cicero</td>
            <td>Bermuda</td>
        </tr>
        <tr>
            <td>Hyatt</td>
            <td>ut.aliquam.iaculis@velquamdignissim.ca</td>
            <td>North Las Vegas</td>
            <td>Sierra Leone</td>
        </tr>
        <tr>
            <td>Jason</td>
            <td>convallis.est.vitae@Sednuncest.ca</td>
            <td>Independence</td>
            <td>Bulgaria</td>
        </tr>
        <tr>
            <td>Jameson</td>
            <td>felis@vestibulumneque.org</td>
            <td>Gilette</td>
            <td>Barbados</td>
        </tr>
        <tr>
            <td>Conan</td>
            <td>egestas.hendrerit.neque@sedsapienNunc.org</td>
            <td>Baldwin Park</td>
            <td>Macedonia</td>
        </tr>
        <tr>
            <td>Len</td>
            <td>Cum.sociis.natoque@Vivamus.edu</td>
            <td>Calabasas</td>
            <td>Cook Islands</td>
        </tr>
        <tr>
            <td>Abdul</td>
            <td>in.consectetuer@eu.com</td>
            <td>Duncan</td>
            <td>Uzbekistan</td>
        </tr>
        <tr>
            <td>Levi</td>
            <td>semper@orci.org</td>
            <td>Carbondale</td>
            <td>Spain</td>
        </tr>
        <tr>
            <td>Hop</td>
            <td>magna.Lorem@tempusrisus.ca</td>
            <td>Ansonia</td>
            <td>Tonga</td>
        </tr>
        <tr>
            <td>Nissim</td>
            <td>primis.in@lobortisnisi.com</td>
            <td>Newburgh</td>
            <td>Pitcairn</td>
        </tr>
        <tr>
            <td>Wade</td>
            <td>In.at@tristiquesenectus.edu</td>
            <td>Guánica</td>
            <td>Kyrgyzstan</td>
        </tr>
        <tr>
            <td>Brennan</td>
            <td>mauris.sagittis.placerat@purusactellus.org</td>
            <td>Meridian</td>
            <td>Venezuela</td>
        </tr>
        <tr>
            <td>Dolan</td>
            <td>tempus.scelerisque@blanditenim.com</td>
            <td>La Palma</td>
            <td>Togo</td>
        </tr>
        <tr>
            <td>Allistair</td>
            <td>nec.tellus.Nunc@etpedeNunc.ca</td>
            <td>Kennewick</td>
            <td>Zambia</td>
        </tr>
        <tr>
            <td>Holmes</td>
            <td>est@sollicitudin.org</td>
            <td>San Antonio</td>
            <td>Jordan</td>
        </tr>
        <tr>
            <td>Jarrod</td>
            <td>congue@elit.org</td>
            <td>Wichita</td>
            <td>Falkland Islands (Malvinas)</td>
        </tr>
        <tr>
            <td>Aristotle</td>
            <td>egestas.Aliquam@sollicitudin.com</td>
            <td>Brown Deer</td>
            <td>Wallis and Futuna</td>
        </tr>
        <tr>o
            <td>Acton</td>
            <td>at.arcu@rutrum.edu</td>
            <td>Baldwin Park</td>
            <td>Solomon Islands</td>
        </tr>
        <tr>
            <td>Harper</td>
            <td>consequat.dolor@acipsumPhasellus.ca</td>
            <td>Costa Mesa</td>
            <td>Philippines</td>
        </tr>
        <tr>
            <td>Cole</td>
            <td>neque.Morbi@Donec.org</td>
            <td>Lima</td>
            <td>Canada</td>
        </tr>
    </tbody>
            </table>
</body>
</html>

Open in new window

ok - I see that but what are you expecting to see by putting exclude on BIG TABLE - I am trying to visualise what the problem is.
Im not sure if exclude is the fix

what i want to be able to do is the BIG table stay on the page it was opened. so it pushes the rows down instead of moving them to page 2
Ok so you want the pagination to igore the table and show say 36 rows when it would normally only show 20 i.e. not break the table?

If so then you are sort of breaking the rules of pagination - and things will become complex.
well my big table is inside 1 row (table inside a row) i dont know how the pagination is calculated, my big table is only ever 1 row as far as pagination is concerned, but it takes the height of say 8 rows.

Is the row height taken into account with pagingation?
ASKER CERTIFIED SOLUTION
Avatar of Julian Hansen
Julian Hansen
Flag of South Africa image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thats the trick!!!

thanks alot for all your help
Awsome - thanks for the points and you are welcome