Search
43827 results 6971-6980
Forum
- 9th Jun 2014Select rows which are not present in other tableokey 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..
- 8th Jun 2014Table won't refreshThanks so much Allan! oTable.api().ajax.reload(); did it, bad oversight on my part. Thanks.
- 2nd Jun 2014dataTables_1.10.0 missing the word "entries" in table length feature when using IE 8Thank 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.
- 1st Jun 2014How do I exclude the span tag from being sorted in a table cell?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
- 29th May 2014Scroll X creates additional blank table heads with sort arrows in themThat 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
- 22nd May 2014Only show sort icons when table header is hovered.Thanks Allan. That served the purpose beautifully.
- 21st May 2014Table tools return "undefined" data while exporting.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
- 8th May 2014How can i reload the ajax data in table.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
- 2nd May 2014Getting all filtered rows in the table failing in 1.10Thanks 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
- 29th Apr 2014Using Datatables jQuery in IE 8 i see issue,Chrome is working fine , in IE8 table shows nullHi 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