jQuery Grid Plugin - jqGrid

Whenever a column is selected to be sorted (including the ID column) and the ID column does not contain consecutive numbers, it re-numbers them.

For example, if we have ids listed as 1, 4, 7, 9, 10. After sorting they get changed to 1, 2, 3, 4, 5.

For users who use the id column to represent the IDs in a database, create a second "hidden_id" column and enter them as strings. When referencing them, use the "hidden_id" attribute to get the correct id.

$("#GRID_LIST_ID").jqGrid({

...

               data: { id:<%=item.getId()%>, hidden_id:"<%=item.getId()%>"...},

onSelectRow: function(id){

                if(id) {
                    var ret = $("#GRID_LIST_ID").getRowData(id);
                    window.location.href = "page_edit.jsp?edit="+ret.hidden_id;
                }
            }

...

}):

Thanks for your time and overall a great plugin.

Jim