Search

29th Jun 2010Initialising table with sAjaxSource error

Hi, Have successfully used datatables but have found a problem when the page is re-loaded whilst the initial load is still in progress with Google Chrome or Firefox. It is fine with IE. Basically, if the page is interrupted, the error is: DataTables warning: JSON Data from the server failed to load or be parsed. This is most likely to be caused by a JSON formatting error. [code] oTable = $('#example').dataTable({ "bSortClasses": false, "sPaginationType": "full_numbers", "bAutoWidth": false, "bProcessing": true, "sAjaxSource": "/Home/DataTables", "iDisplayLength": 20, "aaSorting": [[3, "desc"]], "aoColumns": [ null, null, null, null, null, null, null ] }); [/code] I suspect is need to switch from sAjaxSource to GetJSON() but not clear how to implement it. Can you help please? Thanks, M

26th Apr 2010Only see the table! no functions

On my website i wanne use Jquery plugin Datatables, On my WAMP server it works fine! But on the website with a CMS it doenst work, The only difference is that the CMS first load this page [code] <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>blabla</title> <link href="/CSS/lay-out.css" rel="stylesheet" type="text/css" /> <style type="text/css" title="currentStyle"> @import "/../../template/standaard/css/jquery-ui-1.8.custom.css"; </style> <script language="javascript" src="js/calendar.js"></script> <script type="text/javascript" src="js/jquery-latest.js"></script> <script type="text/javascript" src="js/jquery.dataTables.js"></script> <script type="text/javascript" src="js/jquery-ui-1.8.custom.min.js"></script>  </head> <body bgcolor="#cacaca"> <center><table width="860" class="layout" cellpadding="7" cellspacing="0" border="0"> <tr> <td colspan="2"> <center><img src="" width="860" alt="" /></center> </td> </tr> <tr> <td class="menu" > <?php echo $this->menu(); ?> </td> <td class="content"> <?php echo $this->show_content(); ?> </td> </tr> </table></center> </body> </html> [/code] Then then it loads the page in the content (Show_content) [code] <table id="user"> <thead> <tr> <th>Rendering engine</th> <th>Browser</th> <th>Platform(s)</th> <th>Engine version</th> <th>CSS grade</th> </tr> </thead> <tbody> <tr> <td>Trident</td> <td>Internet Explorer 4.0</td> <td>Win 95+</td> <td class="center">4</td> <td class="center">X</td> </tr> </tbody> <tfoot> <tr> <th>Rendering engine</th> <th>Browser</th> <th>Platform(s)</th> <th>Engine version</th> <th>CSS grade</th> </tr> </tfoot> </table> <script>$(document).ready(function() { oTable = $('#user').dataTable({ "bJQueryUI": true, "sPaginationType": "full_numbers" }); } );</script> [/code] I just dont get it i have tried so much! Can somebody help?

4th Apr 2010How to best achieve custom rendering for a table column

First off, got to say that datables looks awesome. Now onto my issue, I have a datatable with ajax datasource (not server side processing). One of my columns is a list of colors (i.e. #232132), so what I wanted to know is how to best achieve this: I want the cell background with a particular color to be of that color, so if the cell content comes with #ff0000 I want the background for that cell to be of #ff0000, since I am quite new with datatables I wanted to know how to achieve this effect having the datasource returning only a json array of the values Thanks.

19th Mar 2010State Save, Server Side Ajax Tables, and Table Tools - Cookie problem.

Has anyone else using this configuration come across a problem where you goto the print page, then hit the escape button to go back, and error is caused where you lose pagination. If you delete the cookie used to store the state save information, then it will be fixed temporarily, until you try and do that same set of steps again. Here is the actually Cookie itself. [code] {"iStart": 150,"iEnd": 75,"iLength": -1,"sFilter": "","sFilterEsc": true,"aaSorting": [ [0,'asc']],"aaSearchCols": [ ['',true],['',true],['',true],['',true],['',true],['',true],['',true],['',true],['',true],['',true],['',true],['',true]],"abVisCols": [ true,true,true,true,true,true,true,true,true,true,true,true]} [/code] Could the problem possibly be iLength = -1?

13th Mar 2010Multiple table w/ addrow and deleterow functions

Sorry if repost.... I couldn't get this... It took me a whole day but nothing works... read some of the post on this forum still I can't do it... I do think Im a slow learner... Please HELP me Sample table(both table1 and table2) should look something like: Name ImANoob moveToTable1 I think the algorithm is like this.. [code] var oTable;; $(document).ready(function() { oTable = $('.dataTable').dataTable(); } ); /* Add a click handler for the delete row */ $('#moveToTable2').click( function() { oTable.dataTableExt.iApiIndex=0; var nTr = oTable.fnGetData(this); oTable.fnDeleteRow( nTr ); oTable.dataTableExt.iApiIndex=1; oTable.fnAddRow( nTr ); } ); [/code]

20th Mar 2026Adding rows with data-order

of rows to a table, basically the someformatting can

19th Mar 2026State Restore - looping through states and filter data

pretty much in every table. In this case it's

19th Mar 2026Column search value on set

DT2 (latest) + Editor. The table uses server side processing

16th Mar 2026Requested unknown parameter when using `language.url`

No data available in table If entries is people,

4th Mar 2026Problem with excel export (visibility columns) when scrollX enabled

edit code to: var table = $(node).closest('table').DataTable(); return table.column(idx).visible() &&

Search

43891 results 7411-7420

Forum

DataTables