In your case you should set

{
total: “17″,
page: “1″,
records: “68″,

...

}

Regards

Tony

Let's do something. Please return the json sample that I use and adjust your colModel accordinly...

Just to test...

This is now the JSON that I generate dinamically:

{"total":"17","page":"1","records":"68","rows":[{"cell":[32,"01/01/2004","01/01/2009","INT","PE0041","0","*","*","ZEROAR"]},{"cell":[1500,"01/01/2004","01/01/2009","KOR","*","*","*","*","AR08POAGEB"]},{"cell":[3000,"01/01/2004","01/01/2009","GER","*","*","*","*","AR08POAGEB"]},{"cell":[3500,"01/01/2000","01/01/2009","AUT","*","*","*","*","AR08POAGEB"]}]}

I set in the Jqgrid definition:

rowNum: 4

In the server I calculate the number of total pages by totalRecords taken by the query (68) divided by the number of row to view (4).

So i obtained 17 and I set this value on the field total.

Now I view 4 records in the JQgrid but the paging is not active ( there isn't any arrow active in the pager bar).

The problem is that you should return exactly 3 record from the

server and not 5

Regards

Tony

{
total: "2",
page: "1",
records: "18",
rows :[
  {id: "11",cell:["11","ADMISTRACIÓN LEGAL Y FINANZAS"]},
  {id: "4",cell:["4","ASEGURADORA, ARREDADORA FINANCIERA Y OTROS AFINES"]},
  {id: "16",cell:["16","CAJA DE AHORRO, COOPERATIVA O AFINES"]},
  {id: "10",cell:["10","CENTROS EDUCATIVOS Y AFINES"]},
  {id: "2",cell:["2","COMERCIALIZADORA DE PRODUCTOS ELECTRÓDOMESTICOS, COMPUTACIÓN, MAN"]},
  {id: "1",cell:["1","EDITORIAL, VENTA DE LIBROS (MAYOR O DETAL) Y AFINES"]},
  {id: "14",cell:["14","EMPRESAS DE CONSULTORÍA, DESARROLLO DE SOFTWARE Y AFINES"]},
  {id: "17",cell:["17","EMPRESAS DE SERVICIOS EN GENERAL"]},
  {id: "15",cell:["15","FUNDACIÓN SIN FINES DE LUCRO"]},
  {id: "9",cell:["9","INMOBILIARIAS, ADMINISTRADORAS DE BIENES RAÍCES Y AFINES"]}
 ]
}

{"total":"2","page":"1","records":"3","rows":[{"cell":[1,"","","*","*","*","HONEY","*","ARSPOSIALT"]},{"cell":[2,"","","*","*","*","TORATES","*","ARMONIAUKH"]},{"cell":[3,"","","ZAF","*","*","PROMOSA","*","PROMOSAAR4"]},{"cell":[4,"","","SWE","*","*","*","*","ARMSVE5"]},{"cell":[5,"","","AUT","*","*","*","*","ARPROMOAGO"]},{"cell":[6,"","","GER","*","*","*","*","ARFERRAG"]},{"cell":[7,"","","GBR","*","*","*","*","PROMOAUGUK"]},{"cell":[8,"","","AUS","*","*","*","*","ARMAUS1308"]}]}

I have this problem:

I using JQgrid + JSP + Servlet in this manner:

$('#submit').click(function(event) {
        cruiseId = $('#cruiseID').val();
 
        $("#list").jqGrid({
            url: 'DTSServlet?arg='+ cruiseId,
            datatype: 'json',
            colNames:['Prior No.','Booking Start','Booking End','Mkt Code','Agent ID', 'Agent Type', 'Pax Type', 'Plan Code' , 'Price ID'],
            colModel :[
            {name:'priorNo',index:'priorNo', width:60},
            {name:'startDt',index:'startDt', width:85},
            {name:'endDt',index:'endDt', width:85},
            {name:'mktCd',index:'mktCd', width:65},
            {name:'agentId',index:'agentId', width:60},
            {name:'agtType',index:'agtType', width:85},
            {name:'paxType',index:'paxType', width:70},
            {name:'planCd',index:'planCd', width:70},
            {name:'priceId',index:'priceId', width:60} 
            ],
            jsonReader: {
                root: "rows",
                page: "page",
                total: "total",
                records: "records",
                repeatitems: true,
                cell: "cell"
            },
            rowNum: 3,
            imgpath: 'themes/basic/images',
            pager: $('#pager'),
            viewrecords: true,
            caption: 'Pricing Cross Reference For Cruise: '
        }).navGrid('#pager',{edit:false,add:false,del:true});
    });
});

In the servlet I set the response with a JSONObject and I set the parameters for the jsonreader in this way:

total:2

page:1

records: 3

I create an array with 5 elements and I put inside the field rows in a JSON format.

Now, it display all 5 rows without paginating and not 3. Why it doesn't works?