Search

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

That is bizarre. I've just poked and prodded it for 15 minutes and simply can't get the height to be 0... Everything is saying that it should be height 0, but there is something stopping it from being so, can I can't see what. I'll need to come back to this one when I've got a bit more time to spend on it (can't promise when that will be though). Allan

Thanks Allan. That served the purpose beautifully.

I'm going to need more information to be able to offer any help here I think - ideally a test case. Are you using the download get + post plug-in from here: https://datatables.net/extensions/tabletools/plug-ins ? If you add a debug line in to console out the oParams variable, what does it contain? Allan

Please link to a test case, as required in the forum rules. Very likely you are using $().dataTable() rather than $().DataTable(). See the documentation for how to access the API for more information. Allan

Thanks for the clarification. I suspect the error is in the tr part and how DataTables is handling that. Its doing a selector, but the nodes don't exist (since deferred rendering is enabled). I'll take a look into it, but for now, I'd recommend just using the nice new shiny API ;-) Allan

Hi Allan, Thanks for dropping in test case , i was able to run in chorme. but when i copy the same url in ie 8 i see script error . check it out in ie 8 document mode : IE 8