Search

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.

Can you link to your example please? Allan

You would need to bind a custom filtering event handler (and unbind the default one) to the input box - similar to what is done here: http://datatables.net/plug-ins/api#fnSetFilteringDelay . Then your function would need to set the sorting as required using fnSort(). Allan

Any one have any ideas?