Replies

• allan Posts: 63,407Questions: 1Answers: 10,452 Site admin

  August 2009

  First bug in 1.5.0 found...
  
  There is a bug in DataTables when using the 'full_numbers' style of paging. To fix it, find the following line (line 322 in 1.5.0):
  var iPages = Math.ceil((oSettings.fnRecordsDisplay()-1) / oSettings._iDisplayLength) + 1;
  
  and replace with:
  var iPages = Math.ceil((oSettings.fnRecordsDisplay()) / oSettings._iDisplayLength);
  
  This will of course be included in the next release, but I thought I would get the 'word' out as soon as this has been found and fixed.
• troy8x Posts: 1Questions: 0Answers: 0

  August 2009

  For some reasons 1.5 final always displays the text "Processing..." (even when nothing being processed), switch back to beta 11 and the problem goes away.
  
  Anybody experiencing the same problem? Thanks.
• allan Posts: 63,407Questions: 1Answers: 10,452 Site admin

  August 2009

  Interesting - could you post an example? Does that happen for you in the examples I've got up ( http://datatables.net/examples/example_zero_config.html )?
  
  Allan
• jaredcrossley Posts: 8Questions: 0Answers: 0

  August 2009

  I have noticed the same problem mentioned by troy8x. The problem does Not occur in the tables on this site. I confirm, when I switch back to beta 11 the problem goes away. Also, in 1.5.0, after I sort a column in my table, the processing indicator disappears and from there on it appears to work properly.
  
  I've also found another bug. In 1.5.0, only the first 3 of my table columns can be sorted. The remaining columns cannot be sorted and do not display the little sort-indicator icons. In 1.5.beta.11 the column sorting is working properly.
  
  You can see the current state of my application (which at the time of writing employs DataTables 1.5.0) by following this URL: https://webtest.aoc.nrao.edu/crossmatch/crossmatch?scs1=https%3A%2F%2Fwebtest.aoc.nrao.edu%2Fivoa-dal%2FscsVlaObs%3FREQUEST%3Dquerydata%26&scs2=http%3A%2F%2Fheasarc.gsfc.nasa.gov%2Fcgi-bin%2Fvo%2Fcone%2FconeGet.pl%3Ftable%3Dhstaec%26&ra=05%3A34%3A31.97&dec=%2B22%3A00%3A52.1&sr=0.1
  
  Here is my initialization code, if it helps.
  
  [code]
  oTable[tableIndex] = $(oThisTable).dataTable( {
  "aoColumns": setColumnOptions( countTableCols(oThisTable),
  aoColumnsOptArr ),
  "aaSorting": [[1, 'asc']],
  "bProcessing": true,
  "sPaginationType": "full_numbers",
  "fnDrawCallBack": function() {alert('DataTables has redrawn the table');},
  "bAutoWidth": false
  //"bStateSave": true
  });
  [/code]
  
  Thanks for the support.
  
  Jared
• swoyan Posts: 3Questions: 0Answers: 0

  August 2009

  Just wanted to take a minute and say thanks for your awesome work.
  I have been using datatables for a while now. The air/gears and server side paging in this release are great additions.
  Keep up the good work, you make other developer's lives much easier and your work is appreciated.
• orax Posts: 1Questions: 0Answers: 0

  August 2009

  Hi!
  
  The new version of DataTables is not just awesome. In my humble opinion it combines every major aspect of modern web interface, needed for displaying categorized data (news, entries, products, etc.), also paging and filtering included. The biggest and overwhelming feature of it is pulling out data from a server database in a discreet, single-query based way. Even if Allan says that the filterng option (MySQL query case) is limited, actually it is not. The second filtering action is performed on already filtered and thus limited set of previously obtained results. This is exactly what is needed for a lazy type-searcher. Also submitting rows in a form - what an approach to the perfect e-comerce catalogue! I also see the gaming options this feature provides.
  
  I will utilize DataTables in my first project for the new seson as an interface, providing text, videos and titles on each row, slightly modifying the column's titles (not shown). Never again will I need to bother with paging issues and the count of the search results as I needed to at http://www.e-buy.in. I am looking forward to engage DataTables in combination with Ajaxify JQuery Plugin. And thus - building twice as fast, twice as beautiful.
  
  DataTables is an example of what WEB is to become. I think of this application as of "Web Ahead" generation initiator. Thank you Allan! I seriously think that I should order special, modified version of DataTables from you as soon as my developer schedule becomes aparent for the next season.
• andyp Posts: 1Questions: 0Answers: 0

  August 2009

  I'm also seeing the same problems with 'Processing...' as troy8x and jaredcrossley. I don't get the processing issue on the examples on this site or when using the downloaded examples locally. I don't appear to have any sorting issues as reported by jaredcrossley, my 4 column tables sort ok. Unfortunately I'm unable to post my code or a link to an example as it's wrapped up inside another control for a proprietary system we work with.
  
  The 'Processing...' issue is easily solved by using the following snippet of code in your ready function:
  
  [code]
  var dtManaged = $("#dtmanaged").dataTable();
  var oSettings = dtManaged.fnSettings();
  dtManaged.oApi._fnProcessingDisplay(oSettings, false);
  [/code]
  
  which will clear the initial display of 'Processing...' without having to sort.
  
  Otherwise DataTables is of a very high quality and level of functionality, kudos to allan and contributors!
• johnny2002 Posts: 8Questions: 0Answers: 0

  August 2009

  I got a problem with sorting and filtering.
  When the content of the cell isn't pure text, e.g.
  Then, if you type "noname" in the search text box, this row will be displayed, but in fact ,there is no "noname" displayed in the page.
• johnny2002 Posts: 8Questions: 0Answers: 0

  August 2009 edited August 2009

  example:
  [code]
  
  Sample Table
  
  
  select
  first name
  last nameage total discount diff
  
  
  
  
  
  peterparker 28 9.99 20.3% +3
  
  
  peterparker 28 9.99 20.3% +3
  
  
  peterparker 28 9.99 20.3% +3
  
  
  peterparker 28 9.99 20.3% +3
  
  
  $('#tablesorter1').dataTable({"aoColumns": [{ "bSortable": false }, null, null, null, null, null, null]});
  [/code]
  
  Then if I type "noname" in the search box, I don't expected any rows appear, since "noname" isn't visible for user. but row 1 and 2 appear.
• Stuart Posts: 3Questions: 1Answers: 0

  August 2009

  Allan,
  Thanks for the great plugin! I to am experiencing the 'full numbers' pagination bug. I applied the fix as suggested above but I still have an extra page number showing up in the page list. I also discovered that the minified version of the plugin code has this line [code] iPages=parseInt((oSettings.fnRecordsDisplay()-1)/oSettings._iDisplayLength,10)+1;[/code] in that function so there may be a versioning problem with the zip file.
• why910 Posts: 2Questions: 0Answers: 0

  August 2009

  Allan,
  
  Thanks for your great job on DataTables. I love this tool!
  
  I also met the same problem of "Processing..." display after the table initialization.
  I traced the code and found that, in the function "_fnFeatureHtmlProcessing" (line 2785),
  there may missed to hide nProcessing node. So, I add the following code before line 2795
  [code]nProcessing.style.visibility = "hidden";[/code]
  which could be found in previous versions, 1.4.3.
  
  Another questions is that,
  why should this version reset display back to page 0 after sorting? (line 3156)
  Is there any consideration?
  
  Thank you very much!
• allan Posts: 63,407Questions: 1Answers: 10,452 Site admin

  August 2009

  A couple of things in this thread, so I'll try to address them individually:
  
  - Processing showing when it shouldn't be
  @troy8x, jaredcrossley, andyp, why910
  
  This error would occur when using any data source other than an Ajax source and having bProcessing set to true. It just needs the processing to be disabled after the initialisation has completed, much like andyp's code, the basis of which has now been integrated into DataTables core. This fix will be in 1.5.1.
  
  
  - Sorting only on first two columns on complex headers
  @jaredcrossley
  
  This is addressed in this thread: http://datatables.net/forums/comments.php?DiscussionID=516 . The fix will be included in 1.5.1.
  
  
  - Thanks!
  @swoyan, orax
  
  Thank you very much! It's great to hear that DataTables is being so well received and is proving to be useful in so many applications. @orax, please feel free to get in touch if you do need some specific DataTables work. I've got loads of ideas for future versions - anyone want to employ a full time DataTables developer? ;-)
  
  
  - Searching on HTML
  @johnny2002
  
  If you set the sType for the column to 'html' DataTables will strip the HTML such that only visible information will be used for sorting.
  
  
  - full_numbers paging issue
  @Stuart
  
  The full_numbers issue is present in all versions of DataTables 1.5.0 (minified or otherwise). This will be addressed in the soon to be released 1.5.1.
  
  
  - Reset sorting back to 0 after sorting
  @why910
  
  The display is reset after sorting because of user interaction requirements. If you hit a sort button, then you would expect to be taken to the start point of the new sort, rather than some random point in the middle of it. It is possible to develop around this if you wish: http://datatables.net/forums/comments.php?DiscussionID=422
  
  
  Regards,
  Allan