Search

throwing me this error SCRIPT87: Invalid argument. jquery.dataTables.min.js?1344609740, line

to use the server-side scripting because I have very

9, I get a script5007 error indicating "Unable to

when using server side scripting? Example: some data Legacy

two new server-side processing scripts: ASP.NET from LionHeart - http://datatables.net/development/server-side/asp_net

Yes. I use the ajax option to fetch the data from my Python scripts/framework. Details can be found in the Ajax docs. Your python function will need to return a JSON string with the data. See these examples to see the supported data structure. Let us know if you have any questions. Kevin

You don't need a set formatter at all if you just want an empty string to be saved as an empty string (unless you are using an Oracle db or a trigger which will set empty strings to be null). Can you have a look in your database directly (using phpMyAdmin, pgAdmin or whatever database tool you use for your db) and let me know if null is what is actually being stored? Allan

"serverSide": true, That means that all filtering would be done at the server-side. In the example you linked to it is always just loading static data with no filtering being performed which is why it isn't working. Allan

works great, cache was the culprit, thanks!

Okay so I think I have this solved. Apparently I was very far off. Based on this article I was doing a number of things wrong. After doing some reading the code I was trying to use was from a plugin that I didn't include AND also depreciated with the latest release. The correct code should be: var oTable; //... oTable = DataTable(//...); //... function formSubmit() { oTable.search( '' ).columns().search( '' ).draw(); oTable.page.len(-1).draw(); } Here is the reference if you are searching for the same thing I was: https://datatables.net/plug-ins/api/fnFilterClear