jQuery Grid Plugin - jqGrid

Thanks Tony,

With 1 & 3 I was looking in the wrong place - fixed now - your fault for making jqGrid so comprehensive 😉

Your suggestion for 2 works a treat 🙂

As for number 4 ... what seems to be happening is when the grid initially loads the header sent to the url.php is asking for page=0 and the records say "-9 to 0" when returned - although the grid contains records 1-10. As soon as I do a sort or reset then next call is correct for page=1.

I can't see what I'm doing to cause this to happen. The only thing slightly different about the grid is that when I initially set it up I give it a dummy url which I then change using setGridParam and then use trigger("reloadGrid") to fill it.

This is the grid:-

    $("#grid_rm_search").jqGrid({
        url:'php/race_resultssearch.php?r=0',
        datatype: "json",
        autowidth: true,
        height: 'auto',
        shrinkToFit: false,
        colNames:['racer_id','Pos','Bib#', 'Last Name', 'First Name', 'Sex', 'Age', 'Time'],
        colModel:[
            {name:'racer_id',index:'id', width:1, hidden:true, search:false},
            {name:'place_overall', index:'place_overall',width:35, searchoptions:{sopt:['eq','le','ge']}},
            {name:'racer_no',index:'racer_no', width:40, searchoptions:{sopt:['eq','cn']}},
            {name:'last_name', index:'last_name',width:75, searchoptions:{sopt:['eq','bw','ew','cn']}},
            {name:'first_name', index:'first_name',width:75, searchoptions:{sopt:['eq','bw','ew','cn']}},
            {name:'sex', index:'sex',width:25, searchoptions:{sopt:['eq']}},
            {name:'age', index:'age',width:25, searchoptions:{sopt:['eq','le','ge']}},
            {name:'time_complete_dt', index:'time_complete_dt',width:50, search:false}       
        ],
        rowNum:10,
        mtype: "POST",
        pager: '#grid_rm_search_pager',
        sortname: 'place_overall',
        toolbar: [true,"top"],
        viewrecords: true,
        rownumbers: false,
        pginput: false,
        gridview : true,
        sortorder: "asc"
    }).navGrid('#grid_rm_search_pager',
    {
        edit:false,add:false,del:false,search:false,refresh:true
    },
    {}, // edit options
    {}, // add options
    {}, //del options
    {
        multipleSearch:true,
        closeOnEscape:true,
       
    } // search options
    );

and this the reload (where curr_RaceID is an integer param set):

        $("#grid_rm_search").setGridParam({
            url:'php/race_resultssearch.php?r=' + curr_RaceID
        }).trigger("reloadGrid");

Thanks again

Regards

Romyn

Sorry - don't quite understand what you mean with that "trick".

The first call sends the Headers:-

_search false

nd ... (a long number)

page 0

rows 10

sidx place_overall

sord asc

Response begins with (up to start of 2nd record):-

{"page":"0","total":2,"records":"20","rows":[{"id":"19948","cell":["19948","1","8","Keflezighi","Meb","M","34","02:09:14"]},{"id":.........

With that I get the funny records numbers.
After a sort the Headers and Response are the same except

Headers has:- page 1

Response has:- {"page":"1" ........

Not sure if that helps at all?

Romyn

Hi,

I get that - and that's the problem I'm trying to solve.

I don't know what I'm doing that causes the grid to ask for page 0.Why is page 0 in my Headers and thereofre in the Response?

Put it another way - if I wanted to open the grid on page 5 what would I need to do.

Thanks

Romyn

That's a good question which unfortunately I don't know the answer.

I just copied one of the examples and changed the Select to point to my table structure. I don't know why it's doing what it's doing and I'll have to look into it and hopefully find a permanent solution.

In the meantime I've amended the PHP by adding near the beginning...

if ($page == 0) {
    $page =1;
}

... and that seems to sort the problem out - although obviously the underlying cause is still there somewhere.

Thanks very much Tony for your time, and patience, I'm very grateful for it.

Kindest regards

Romyn