jquery datatables-一个数据表中的最大列数

Hi I'm trying to develop a UI for an oracle table which has around 40 columns/fields using jquery datatbles plugin. I'm able to display upto 18 columns, but after that it's not working. Is anyone else faced the same issue before? Please advice me on this i'm pretty new with jquery.

嗨，我正在尝试使用jquery datatbles插件为oracle表开发一个UI，该表有大约40个列/字段。我能够显示多达18列，但之后它不起作用。以前是否还有其他人遇到过同样的问题？请告诉我这个我对jquery很新。

`Sorry for that...

when i'm trying to create a UI for my oracle table, when i configure it for 18 columns(any 18) i can see my UI is working perfectly. But if i add one more column and update the configuration my UI is not loading.

当我试图为我的oracle表创建一个UI时，当我为18列（任何18）配置它时，我可以看到我的UI工作正常。但是如果我再添加一列并更新配置，我的UI就不会加载。

<script type="text/javascript">
     $(document).ready(function () {
       $("#reports").dataTable({
            "bServerSide": true,
            "sAjaxSource": "/databaseInterface/DataSource",
            "bProcessing": true,
            "sPaginationType": "full_numbers",
            "bJQueryUI": true,
            "aoColumns": [
                          {  "sName": "ID",
                             "bSearchable": false,
                             "bSortable": false,
                             "bVisible": false
                                 },
                  { "sName": "name" },
                  { "sName": "sname" },
                  { "sName": "address" },
                  { "sName": "city" },
                  { "sName": "post code" },
                  { "sName": "age" },
                  { "sName": "major" },
                  { "sName": "grade" },
                  { "sName": "Elect1" },
                  { "sName": "Elect2" },
                  { "sName": "Elect3" },
                  { "sName": "Elect4" },
                  { "sName": "Elect5" },
                  { "sName": "Assig1" },
                  { "sName": "Assig2" },
                  { "sName": "Assig3" },
                  { "sName": "Assig4" },
                  { "sName": "Assig5" }
                 ]
     }).makeEditable({
            "aoColumns": [
                          {},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}
                      ]
                      });
    });
    </script>

this is my sample code which is working properly, and is i add { "sName": "Status" } at the end, and update my datasource with the corresponding value it's not displaying aything in my UI. `

这是我的示例代码，它正常工作，并且我在最后添加{“sName”：“Status”}，并使用相应的值更新我的数据源，它不会在我的UI中显示任何内容。 `

jquery 1.8, java 5 and also jquery editable datable plugin

jquery 1.8，java 5以及jquery可编辑的datable插件

I'm trying to display my oracle table like a datatable shown in this website datatable reference that i'm using

我正在尝试显示我的oracle表，就像我正在使用的这个网站数据表参考中显示的数据表一样

1 个解决方案

#1

Very likely the problem is that your server is rejecting GET requests which have more than a certain number of characters. By default DataTables sends server-side processing requests as GET. To change to POST use the sServerMethod option - http://datatables.net/ref#sServerMethod .

很可能问题是您的服务器拒绝具有超过一定数量字符的GET请求。默认情况下，DataTables将服务器端处理请求作为GET发送。要更改为POST，请使用sServerMethod选项 - http://datatables.net/ref#sServerMethod。

1 个解决方案

#1

更多相关文章

随机推荐