Search

Hello, I'am working with the datable. I'have an issue with IE7 : the sortable column can't be focusable with the "Tab" key (it's working fine with IE8 and firefox). I checked the generated source code, and the "tabindex" property is correctly put to "0" on each element of the but it's not workink... Do you know how can I fix this issue? Thanks and regards

Step 1: extend dataTableExt.oSort with the following code: [code] $.extend($.fn.dataTableExt.oSort, { "numeric-pre": function(a) { a = (a === "-" || a === "") ? 0 : a.replace(/[^\d-.]/g, ""); return parseFloat(a); }, "numeric-asc": function(a, b) { return a - b; }, "numeric-desc": function(a, b) { return b - a; } }); [/code] Step 2: extend dataTableExt.aTypes, add comma to sValidChars variable: [code] # Added comma to sValidChars $.extend $.fn.dataTableExt.aTypes, [ /* * Function: - * Purpose: Check to see if a string is numeric * Returns: string:'numeric' or null * Inputs: mixed:sText - string to check / function (sData) { / Allow zero length strings as a number */ if (typeof sData === 'number') { return 'numeric'; } else if (typeof sData !== 'string') { return null; } var sValidFirstChars = "0123456789-"; var sValidChars = "0123456789.,"; var Char; var bDecimal = false; /* Check for a valid first char (no period and allow negatives) */ Char = sData.charAt(0); if (sValidFirstChars.indexOf(Char) == -1) { return null; } /* Check all the other characters are valid */ for (var i = 1; i < sData.length; i++) { Char = sData.charAt(i); if (sValidChars.indexOf(Char) == -1) { return null; } /* Only allowed one decimal place... */ if (Char == ".") { if (bDecimal) { return null; } bDecimal = true; } } return 'numeric'; }, /* * Function: - * Purpose: Check to see if a string is actually a formatted date * Returns: string:'date' or null * Inputs: string:sText - string to check */ function (sData) { var iParse = Date.parse(sData); if ((iParse !== null && !isNaN(iParse)) || (typeof sData === 'string' && sData.length === 0)) { return 'date'; } return null; }, /* * Function: - * Purpose: Check to see if a string should be treated as an HTML string * Returns: string:'html' or null * Inputs: string:sText - string to check */ function (sData) { if (typeof sData === 'string' && sData.indexOf('<') != -1 && sData.indexOf('>') != -1) { return 'html'; } return null; } ]); [/code] http://stackoverflow.com/a/16129840/888737

supoose in datable i have 10 record show in first page .and paging count show 1 to 10 record. after that when we delete one record from datable paging and page count not reset i.e they show same i,e 1to 10 record .they cant show 1 to 9 record . Plz help me how to apply paging or reset again.

I have implemented ColorBox along side jquery datatables. I have a problem though. Everything works 100% in that when the user clicks the a specific link in the datatable, an iframe pops-up and the user is displayed an input form. My problem is that if the user re-sorts any column (provided there are more than 10 records) in the datatable, when the link is then clicked, the input form appears in a new tab and not in the colorbox popup. I contacted the developer of colorbox and he replied saying he was unsure possibly "datatables plugin isn't moving the actual elements around in the DOM, but is re-creating them. This would cause them to lose things like bound data and event listeners, which colorbox relies on" Is this possibly what is happening??

Is there anyway for datatable plugin to ignore hidden rows so the alternate row color doesn't get mess up and the sInfo will display the right number of rows. When i hide a row the sInfo information of total rows does not match the number of visible rows. Same problem with filter/search. Thanks. P.S. I can not remove rows.

the data is when sorted as desc -2,598.00 -3,493.70

Hi, I'm new here, and I know very little javascript ... I wood like to have one column with dates (formats : jj/mm/yyyy ou day month year), but I don't now how done ... Please, help me ... Thanks a lot. Marc from Paris

I love this product very much. And I played with it when I deal with some numbers. Now I hope to show a order number in the first column, and when I re-sort by other column values, it will keep 1,2,3,4,...N Is there any existed settings to take advantage of? Thanks.

my standard Data Table's sorting icons? Ideally it'd work

Hi I'm using Datatables 1.9 and 'm new to jquery, when i tried to add a new column to the my existing code if i tried to sort/search it's returning nullpointer exception j ava.lang.NullPointerException at jquery.datatables.controller.DataTableAjaxDataSourceServlet$1.compare code case 4: result = c1.getobj().compareToIgnoreCase(c2.getobj()) * (param.sSortDir[i].equals("asc") ? -1 : 1); Anyone else is facing the same issue?