Search

The problem now is solved. It's my fault. The right way of calling this action is: "aLengthMenu": [[25, 50, 100, -1], [25, 50, 100, "All"]]

Edits made in initial post !

Allan/Kussie, yes, that was exactly it. I removed the quotes and everything flew perfectly. p.s. It also removed the need for my next call which was going to be "Why does the info show as 'records 1 to 020 of 1,922'"? (i.e. have a leading zero!) Thanks again to you both, Pete.

It doesn't work for me. For some reason, if there are many columns of different types, the search goes on "Processing..." without explaining why is failing

p.s. All was o.k., but I wanted to have the dropdown list sorted. Fortunately, this was a simple thing todo (once I'd found this post: http://datatables.net/forums/discussion/comment/17116#Comment_17116)

Is it possible this php code is causing the error about columns. It's used when our table is created and also in the ajax refresh code. Depending on a condition we are setting a div class. But the programmer wrapped the entire td element instead of just running the if else around the div class inside the td. [code] [/code]

Should look harder next time (searched the API and stuff but didn't see anything before I posted.)... Found the answer http://datatables.net/plug-ins/api#fnSetFilteringDelay

Lots of people here :-) I don't quite understand - a link to illustrate would be very useful. Are your server error logs showing any 404 errors? If it isn't automatically being picked up as numeric then it likely has non-numeric characters in it (such as , or ' etc). Again a link would be useful. Allan

Here is where I initialize the datatables plugin: [code] jQuery.fn.dataTableExt.oSort['num-html-asc'] = function(a,b) { var x = a.replace( //g, "" ); var y = b.replace( //g, "" ); x = parseFloat( x ); y = parseFloat( y ); return ((x < y) ? -1 : ((x > y) ? 1 : 0)); }; jQuery.fn.dataTableExt.oSort['num-html-desc'] = function(a,b) { var x = a.replace( //g, "" ); var y = b.replace( //g, "" ); x = parseFloat( x ); y = parseFloat( y ); return ((x < y) ? 1 : ((x > y) ? -1 : 0)); }; $(document).ready(function() { $('#myTable').dataTable( { "sScrollY": "465px", "bScrollCollapse": true, "bJQueryUI": false, "bAutoWidth": false, "bPaginate": false, "aoColumns": [ null, { "sType": 'num-html' }, null, null, null, null, null ], } ); } ); [/code] Here is the part where I coded my table where it populates with items. [code] < table width="100%" height="100%" border="0" cellspacing="0" cellpadding="0"> < table id="myTable" width="100%" height="100%" border="0" cellspacing="0" cellpadding="2" align="left" style="position:relative; bottom:-3px; left:0px;"> <tr> <%[/code]

Ok I resolved it myself. I removed the parameter colIndex and just hard coded the column index directly and then I switched to a different callback, fnDrawCallback. I also changed my td in the last line to th, since I'm dealing with headers and not plain cells.