jQuery Grid Plugin - jqGrid

tony said:

Hello,

Check your rowNum parameter in jqGrid. Also check if your server return the correct data.

Regards

Tony

Hi

Great control!

Actually, i do have it set to 1000 and the server is sending 1000 rows of data. I included some details. Let me know if you need more!

jQuery("#list2").jqGrid({
    url:'/iBatisPlay/experimental/data.json?nd='+new Date().getTime(),

    datatype: 'json',

        jsonReader : {
          root: "rows",
          page: "page",
          total: "total",
          records: "records",
          repeatitems: true,
          cell: "cell",
          id: "id",
          userdata: "userdata",
          subgrid: {root:"rows",
            repeatitems: true,
            cell:"cell"
          }
        },  
       
    colNames:['#','Contact Name','Last Name','First Name','Company','Phone','Address','Email'],  

    colModel:[
        {name:'ID',index:'ID',width:50,sorttype:"float"},
        {name:'ContactName',index:'ContactName',width:125, editable: true},
     {name:'lastname',index:'lastname', width:75},
        {name:'firstname',index:'firstname', width:75},
        {name:'company',index:'company', width:125},
        {name:'phone',index:'phone', width:125},
        {name:'address',index:'address', width:250},
        {name:'email',index:'email', width:125}
    ],
   
    pager: jQuery('#pager2'),

    rowNum:1000,
   
    imgpath: '/ibatisplay/experimental/images',

    sortname: 'id',

    viewrecords: true,
   
    sortorder: 'desc',
   
    caption: 'Contacts DEMO',
   
    loadonce: true,
   
    loadtext: "Loading contacts...",
   
    multiselect: true,   
   
    multiboxonly: true,
   
    toolbar: [true,"top"],
   
    height: "50%"
});
});

Snippet of Data

{total: 11,

page: 1,

records: 1000,

rows: [

{id: '14835', cell:['1','','','','Knoll Showroom','416-365-3000 (Office Direct)','109 Atlantic Avenue Suit 200 -- Toronto -- ON -- -- M6K 1X4','']}

,{id: '14762', cell:['2','(Akan) Bowyer, Sheila','(Akan) Bowyer','Sheila','RBC Dexia Investor Services Trust','416-955-3514 (Office Direct)','200 Bay Street, 24th Floor -- Toronto -- ON -- Canada -- M5J 2J5','sheila.bowyer@rbcdexia-is.com']}

,{id: '14859', cell:['3','007, Contact','007','Contact','','','','']}

,{id: '792', cell:['998','Bezalel, Aharon','Bezalel','Aharon','','0119-722-641-1455 (Office General)','Mevo Hashar 3 Ein-Kerem -- Jerusalem 95-744 -- Israel','rachelfr@zahav.net.il']}

,{id: '1917', cell:['999','Bhardwaj, Rahul','Bhardwaj','Rahul','The AGO Foundation','905-474-9974 (Office General)','United Way York Region 80F Centurian Drive Suite 200 -- Markham -- ON -- Canada -- L3R 8C1','rbhardwaj@uwyr.on.ca']}

,{id: '793', cell:['1000','Bhargava, Paras','Bhargava','Paras','BMO Nesbitt Burns','416-359-6941 (Office Direct)','1 First Canadian Place 100 King Street West P. O. Box 150 -- Toronto -- ON -- Canada -- M5X 1H3','']}

]}

Thank you

Abel

My problem was that the data was NOT formatted correctly. I added one row at a time (15, 16, 17 etc...) to discover the individual column data was the problem.