I have the following code


Set RScatf = Server.CreateObject("ADODB.Recordset")
RScatf.CursorLocation = 3 ' adUseClient
RScatf.Open SQL, objconn
' Set the page size of the recordset
RScatf.PageSize = nItemsPerPage

' Get the number of pages
nPageCount = RScatf.PageCount
' response.write "pagecount:" & npagecount

This works great but if I have exactly 12 items on a page it makes the page count 2 and puts 11 on the first page and 1 on the second

does anyone know why this would be