Search

I am having an issue with the DataTables plugin an KnockoutJS. When I populate the table with Knockout bindings the DataTable comes up perfectly. When you click sort or page it clears the tables and displays 'No data available in table'. Below is the knockout bindings I am using. Here is the actual data and the classes that we are using with the table bindings. ViewModel = jQuery.parseJSON( "{"orders":[{"OrderID":11111111,"OrderStatusID":7,"OrderDate":"/Date(1401721692707)/","FirstName":"Evolv","LastName":"Master Distributor 4","Company":"","SubTotal":72,"ShippingTotal":9.75,"TaxTotal":"","Total":81.75,"CurrencyCode":"usd","WeightTotal":1.2,"BusinessVolumeTotal":40,"CommissionableVolumeTotal":60,"TrackingNumber1":"","TrackingNumber2":"","TrackingNumber3":"","TrackingNumber4":"","TrackingNumber5":"","ShippedDate":"/Date(-62135575200000)/"},{"OrderID":11111122,"OrderStatusID":7,"OrderDate":"/Date(1398288995000)/","FirstName":"Evolv","LastName":"Master Distributor 4","Company":"","SubTotal":10,"ShippingTotal":"","TaxTotal":"","Total":10,"CurrencyCode":"usd","WeightTotal":0.5,"BusinessVolumeTotal":"","CommissionableVolumeTotal":"","TrackingNumber1":"","TrackingNumber2":"","TrackingNumber3":"","TrackingNumber4":"","TrackingNumber5":"","ShippedDate":"/Date(-62135575200000)/"},{"OrderID":11111123,"OrderStatusID":7,"OrderDate":"/Date(1398288835000)/","FirstName":"Evolv","LastName":"Master Distributor 4","Company":"","SubTotal":10,"ShippingTotal":"","TaxTotal":"","Total":10,"CurrencyCode":"usd","WeightTotal":0.5,"BusinessVolumeTotal":"","CommissionableVolumeTotal":"","TrackingNumber1":"","TrackingNumber2":"","TrackingNumber3":"","TrackingNumber4":"","TrackingNumber5":"","ShippedDate":"/Date(-62135575200000)/"}]}"); EvolvCart.OrderHistory = function (OrderHistory) { var self = this; self.OrderID = ko.observable(OrderHistory.OrderID || ''); self.OrderStatusID = ko.observable(OrderHistory.OrderStatusID || ''); self.OrderDate = ko.observable(OrderHistory.OrderDate || ''); self.FirstName = ko.observable(OrderHistory.FirstName || ''); self.LastName = ko.observable(OrderHistory.LastName || ''); self.Company = ko.observable(OrderHistory.Company || ''); self.SubTotal = ko.observable(OrderHistory.SubTotal || ''); self.ShippingTotal = ko.observable(OrderHistory.ShippingTotal || ''); self.TaxTotal = ko.observable(OrderHistory.TaxTotal || ''); self.Total = ko.observable(OrderHistory.Total || ''); self.CurrencyCode = ko.observable(OrderHistory.CurrencyCode || ''); self.WeightTotal = ko.observable(OrderHistory.WeightTotal || ''); self.BusinessVolumeTotal = ko.observable(OrderHistory.BusinessVolumeTotal || ''); self.CommissionableVolumeTotal = ko.observable(OrderHistory.CommissionableVolumeTotal || ''); self.TrackingNumber1 = ko.observable(OrderHistory.TrackingNumber1 || ''); self.TrackingNumber2 = ko.observable(OrderHistory.TrackingNumber2 || ''); self.TrackingNumber3 = ko.observable(OrderHistory.TrackingNumber3 || ''); self.TrackingNumber4 = ko.observable(OrderHistory.TrackingNumber4 || ''); self.TrackingNumber5 = ko.observable(OrderHistory.TrackingNumber5 || ''); self.ShippedDate = ko.observable(OrderHistory.ShippedDate || ''); } EvolvCart.OrderHistoryClass = function () { var self = this; self.orders = ko.observableArray(); } EvolvCart.orderHistoryViewModel = new EvolvCart.OrderHistoryClass(); Order ID First Name Last Name Order Date Total

I am using server-side php to grab data from my database in pdo style using the script found here - https://gist.github.com/jjb3rd/3156545 Searching is not working for me and not sure why... everything else is working fine. Any ideas? DataTables warning (table id = 'sample_1'): DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error. Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY093]: Invalid parameter number' in /home/test/public_html/assets/data-tables/test-pdo.php:99 Stack trace: #0 /home/test/public_html/assets/data-tables/test-pdo.php(99): PDOStatement->execute() #1 /home/test/public_html/assets/data-tables/test-pdo.php(143): TableData->get('accounts', 'account_id', Array) #2 {main} thrown in /home/test/public_html/assets/data-tables/test-pdo.php on line 99 line 99 is - $statement->execute(); from Bind Parameters Aside from this issue... how the heck do I only return specific rows from the database? In my situation nearly every instance where I use datatables I do not want to return all rows in the table because I will need to use something like WHERE user=user or WHERE id=id so only specific data is returned and allowed to be sorted.

30 rows and I searched all rows, which contain

how to do that...

please help .... how to do this.. via datatables jquery

I am getting row data from my viewmodel. Whenever i type "administrator", it gets all the result instead of displaying only text with administrator. eg. name admin1 user1 user2 so if i type "admin" it gets all the results instead of just retrieving 'admin1'. Other than that it works fine. Does anyone kno why this is happening? any help would be appreciated. Here's my code //datatable $('#administrators_gridView').dataTable({ "iDisplayLength": 25 }); //table element < table id="administrators_gridView" class="">

is it possible to filter for either a string (rather than individual words) or filter only on visible columns ? for example I have a list of singers, each grouped by their voice, if i apply a filter for 'tenors 2', i get all tenors 2 and a few tenors 1 as well, as they have a 2 in either an email address or memberid (which is hidden, but required for a link).

Hello, I have one table which works fine but the seconde one is a bit particular. My first table contains one object by row but my second table contains one object and this object is displayed in many rows (i give to datatable a json using django). Doing this, having only one object but many rows, sorting and searching doesn't work. Do you have any idea of how i can run this properly? I can at least sorting my first column with dictsort in my template but it's not sufficient by far. =/

and I noticed the search/filter box doesn't work despite

type anything on the searchbox, the table displays no