Search

Thanks Allan, I've used the flag method as suggested and it seems to work just fine. [code] var halt=false; $(document).ready(function() { editor = new $.fn.dataTable.Editor({ ajaxUrl: "./worklog.ajax.php", domTable: "#worklog", events: { onOpen: function(){halt=true; }, onClose: function(){halt=false;} }... [/code] [code] setInterval(function() { if(!halt) { dTable.fnReloadAjax("./worklog.ajax.php"); } }, 120000); [/code]

You've enabled server-side processing, but your data source doesn't implement server-side processing. If you want to use server-side processing you need to implement the protocol described here: http://datatables.net/usage/server-side For that few rows though, I'd suggest you don't use server-side processing - there is no need. Allan

Problem solved. I used mRender for input.

Add it to the part of the script where the WHERE section is built up. Around line 100. Allan

I'm a little confused I'm afraid - I'm not 100% sure exactly what you are asking. I'll try to answer the individual points raised: 1. [quote] TableTools._aInstances[0].s.dt.aoData [NOTE: mostly because of my ignorance, it took me a loooong time of poking around to find the location above [/quote] You really don't want to be accessing those variables directly - they are private (anything starting with an underscore in DataTables land is considered private). Might be useful for debugging, but I'd really recommend you just use the public API to get data and manipulate the table. Certainly manipulating aoData is a great way to break things :-). So, what's the right way to get the JSON data into a hidden form element on submit, for an existing form on the page, so that it shows up in $_POST over in the PHP script? You are trying to get the data form the table, or from the localStorage element? From the table use fnGetData - from localStorage, just read it directly. Editor should keep the localStorage up-to-date when working with it's crud controls. It might not be perfect for your use case - there might be some changes needed (it uses indexing as the row ID for example, which is fairly useless if you have a server-side database somewhere with a unique serial column). It sounds like localStorage and the data are getting out of sync. I'm sure sure why that is - a link would be useful to see what is happening. Allan

Hi - thanks for posting back, and for the railscasts link - I hadn't seen that one before :-). Good to hear you got it sorted. Its worth pointing out that DataTables can consume data from just about any JSON format, as described in this blog post: http://datatables.net/blog/Extended_data_source_options_with_DataTables Allan

there was a problem with the routings, thanks!

q

This would probably work as well: [code] $("#alltickets input[type=checkbox]").click(function() { allTable.fnReloadAjax('get_tickets', createClickableRowsAllTickets); }); [/code] i.e. passing the createClickableRowsAllTickets function, rather than the result of calling it. Good to hear you got it working. Allan

Was a tickle to fast stating that the discussion can be closed. I now obviously run into the prob that the Open image is still shown and not the closed one. How do I now get to a level in the row so that I can change the picture similar to: [code] this.src = "images/details_close.png"; [/code] I tried nTr.cells[0] and then change the value but I guess that is not the correct approach as it didn't work Cheers D