Search

add events, class name information or otherwise format the

plug-ins page for further information.

selector operation. For more information about column selectors, please

columnDefs.targets option provides the information required by DataTables for

it can provide useful information that describes the error

This feature doesn't provide table control or information itself, rather it provides an easy mechanism that you can use to place HTML or text around a table in the DataTables controlled layout grid.

can be used to inform you of this state.

to give exactly this information. The draw event is

DataTables API. For more information about the original method,

be able to add information to the DataTables state

Thanks for the test case. I don't think there is anything wrong with your server-side processing script, it looks like the state saving that is going wrong. It looks like the iStart parameter is being given as a string, and not an integer. I think this is probably because it is being sent as a plain HTTP variable which of course has no type. What I'd suggest you do is JSON.stringify the state object before sending it to the server and then using that to save and return. Then type is retained. I'll update my example to reflect this. Allan

Try this. http://code.google.com/p/jquery-datatables-in-line-editing/downloads/detail?name=CreativePathExample.zip&can=2&q= It's a real basic working example that reads/write from a database. I got this up and running really quick. I wish I had stumbled on this earlier. It would have saved me a few days of work not to mention frustrations. It's exactly what I wished for, which was an example I could just plop into my www folder that includes a database I could just import. Just follow the directions in readme.php. Only problem I encountered was an error when importing the sql file into mysql database in phpmyadmin was that it didn't recognize " latin1$$". This was easily solved by removing "DEFAULT CHARSET=latin1$$" from the file.

Thanks Allan...yes, I see that is exactly what I need!

Excellent to hear you got it working :-). And thanks for your kind words! Allan

Okay makes sense on not manipulating the fnsettings directly. I'll revisit later since I have a workaround for now to just manually destroy and recreate the table with the new data. Seems a bit odd that the table renders fine though and only fndestroy is the issue.

A little bit of CSS? [code] .dataTables_info { width: auto; float: right; } [/code] Allan

Sigh. Of course I do. Gar, thanks. g.

Agreed - you need to use a sorting plug-in. The formatted numbers plug-in might be the best option. Allan

[code] $.fn.dataTable.version [/code] will get you the version. Its documented in the API docs here: http://datatables.net/docs/DataTables/1.9.4/#version - but not on the main site :-(. I'll get that sorted out :-) Allan

Exports as in the files created by TableTools, or something else? If TableTools, then you can use http://datatables.net/extras/tabletools/button_options#fnCellRender to manipulate the string before it is exported. Allan