2016-11-16 05:23
浏览 369


Following is my code. I want to sort the data by clicking on the table header. But it is not working.

                    url: 'ajaxFetchTableInfo.php?table=GET_TRAINING_TYPE',
                    editurl: 'ajaxSaveTrainingType.php',
                    datatype: "json",
                    colNames: ["TRAINING TYPE ID", "TRAINING TYPE NAME", "REMARKS"],
                    colModel: [
                            label: 'TRAINING_TYPE_ID',
                            name: 'TRAINING_TYPE_ID',
                            index: 'TRAINING_TYPE_ID',
                            sorttype: "text",
                            width: 75                        
                            label : 'TRAINING_TYPE_NAME',
                            name: 'TRAINING_TYPE_NAME',
                            index: 'TRAINING_TYPE_NAME',
                            width: 140,
                            editable: true, // must set editable to true if you want to make the field editable
                            editoptions: {size:50, maxlength: 80},
                            editrules:{required: true, maxlength: 80},
                            sorttype: "text",
                            // set options related to the layout of the Edit and Add Forms
                            formoptions: {
                                colpos: 1, // the position of the column
                                rowpos: 2, // the position of the row
                                label: "Training Type Name:", // the label to show for each input control  
                                elmsuffix: "(*)"                 

                            label : 'Remarks',
                            name: 'REMARKS',
                            width: 100,
                            editable: true,
                            edittype: 'textarea',
                            editoptions:{rows:3, cols:45},
                            formoptions: {
                                colpos: 1,
                                rowpos: 3
                    loadOnce : true,
                    viewrecords: true,
                    altRows: true,
                    width: 780,
                    height: 200,
                    rowNum: 10,
                    rowList:[10, 20, 30],
                    caption:"Training Type Information",
                    sortname: 'TRAINING_TYPE_ID',
                    sortorder: "asc",
                    emptyrecords: "No Records to Display.",
                    //footerrow: true,
                    pager: "#perpage"
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douteng5673 2016-11-16 05:51

    You should replace loadOnce : true to loadonce : true. The server should return all data (all pages) from the server (url: 'ajaxFetchTableInfo.php?table=GET_TRAINING_TYPE').

    点赞 打赏 评论

相关推荐 更多相似问题