Search

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?

I got it working using only text in the cells of body rows then using an onclick event on the table cell to retain link functionality.

You can use fnFilter ( http://datatables.net/api#fnFilter ) to pass in a regular expression you want to match on, including 'starts with'. Allan

For those finding this thread and having missed the example with select dropdowns as I did, here it is: http://www.datatables.net/examples/api/multi_filter_select.html (I had no part in that, just repasting the link to "answer" this thread)