Datatabke showing 100 records after sorting on any column

ABinBoston

I am using Dreamweaver and Classic ASP (ASP 3.0) with a datatable

It works perfectly except for one issue

When Sorting any column, it shows 100 records after sorting instead of the 10 records, 25 records, or 50 records where the dropdown was set before clicking a column to sort records

Also, after sorting, when it shows 100 records - the text at the bottom still says "Showing 1 to 10 of 212 entries"

If I select 100 records from the dropdown prior to sorting, and click a column to sort - it works fine - it stays at the 100 records, and sorts

it is when the records are set to less than 100 that I have the issue

Does anyone know how I can fix this

Thanks

AB

Code below
-------------------------------



<!-- START TABLE -->



Contacts - List View











<!-- Start Data Tables Initialisation code -->



$(document).ready(function() {
     oTable = $('#example').dataTable({
         "bJQueryUI": true,
         "sPaginationType": "full_numbers"
         });
     } );
    






<!-- End Data Tables Initialisation code -->






Lastname
Firstname
Company









<% While ((Repeat1__numRows <> 0) AND (NOT rsContacts.EOF)) %>

<%=(rsContacts.Fields.Item("LastName").Value)%>
<%=(rsContacts.Fields.Item("FirstName").Value)%>
<%=(rsContacts.Fields.Item("Company").Value)%>

<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rsContacts.MoveNext()
Wend
%>







<!-- END TABLE -->


}
}

allan

Can you link us to your page please?

Allan