Search

The export buttons in TableTools use Flash. So if Flash is not available the buttons simply don't show. I have a blog post with thoughts about the state of HTML5 for replacing the use of Flash in TableTools. Allan

Before it was returning the index of the data position in the array, which was the page order, rather than the row order. Your fix is bob on. You might want to also consider using using row().data() rather than the old fnUpdate method (since you are already using the new API): http://jsfiddle.net/wvzntjv7/5/ . Eventually I plan to add a function selector option to row() (and friends) so you would be able to do that update in a single statement... Allan

if ( ! isset( $_POST['action'] ) ) { $data = $db->sql( 'SELECT id as DT_RowId, field1, field2, ... FROM ... WHERE ... ' )->fetchAll(); echo json_encode( array( 'data' => $data ) ); } else { ... editor stuff } I think should do it. Allan

Actually broken in the offiial examples as well: http://datatables.net/examples/basic_init/scroll_y.html Any good fixes for this? The vertical scrollbar isn't affecting tbody width, but the datatable scroll body width - which apparently the header isn't adjusted for.

Nice... totally had no idea it would do that, but that's great.

How does your dataTable Setup looks like? Do you have a live example?

okey but i don't know how to use it to put it in a drop box $our['pcc_employee'] = $db ->sql('SELECT e.id ,e.Badgenumber, e.Name FROM pcc_employee e WHERE NOT EXISTS (SELECT 1 FROM pcc_empcollege c WHERE e.Badgenumber = c.empid) order by e.Name') ->get( 'e.Badgenumber as value, e.Name as label' ) ->fetchAll(); so if u could kindly teach me how :). here is my sample code..

Thanks so much Allan! oTable.api().ajax.reload(); did it, bad oversight on my part. Thanks.

Thank you. The Nightly build v1.10.1-dev works! In IE 8 the word "entries" shows up in the Length feature. I have posted another question concerning nightly vs release builds. Thanks again.

In datatables 1.9, I would do something like this: $('#players-table').dataTable({ aoColumnDefs: [{ mData: function (source, type, val) { if (type === 'set') { source[iColIndex] = val; return; } else if (type === 'sort') { // source[iColIndex] = is the cell value (<td> DATA THAT NEEDS TO BE SORTED <span>Data Label</span> </td>) // return the right data to sort } return source[iColIndex]; }, aTargets: [iColIndex] }] }); iColIndex is the column index