Search

hi Allan, thanks for your answer, i was testing and to the change the property "type" to "POST" and started to work good, now i have a couple of doubts or suggestions that could serve to improve. Best regards.

Thank you for the clarification! submitError works perfect!

Can you link to a test case showing the problem, as per the forum rules. I don't immediately see any problem with the above code. It should always send the data address by fnServerData on each request since you have enabled server-side processing. Allan

Is d.myKey available in scripts/server_processing.php then for that example or...? Yes - in that case you will be able to use $_GET['myKey'] to get the parameter. Is that the type of thing this is intended for? Bang on! You might use something like: $(document).ready(function() { $('#example').dataTable( { "processing": true, "serverSide": true, "ajax": { "url": "scripts/server_processing.php", "type": "POST", "data": function ( d ) { d.range_start = ...; d.range_end = ...; } } } ); } ); filling in the ... with how you get your values of course! Then you will have $_POST['range_start'] and $_POST['range_end'] at the server-side (I've used POST in this example, while the linked example uses GET). Does that make sense? Regards, Allan

Found solution. I was able to do it with fsServerData parameter. In case anyone needs something similar, this is how you can do. Error Handler handleAjaxError can be modified based on your requirement. [code] function handleAjaxError( xhr, textStatus, error ) { document.location.reload(true); } $(document).ready(function() { $.fn.dataTableExt.sErrMode = 'throw'; $('.datatable').dataTable( { "sDom": "<'row-fluid'<'span4'l><'span8'f>r>t<'row-fluid'<'span4'i><'span8'p>>", "bProcessing": true, "bServerSide": true, "sAjaxSource": "your URL", "sPaginationType": "bootstrap", "oLanguage": { "sLengthMenu": "MENU records per page" }, "fnServerData": function ( sSource, aoData, fnCallback, oSettings ) { oSettings.jqXHR = $.ajax( { "dataType": 'json', "type": "GET", "url": sSource, "data": aoData, "success": fnCallback, "timeout": 15000, "error": handleAjaxError "error": handleAjaxError }); }, ...... [/code] If anyone has better suggestion, please post it.

:-) No worries. Good to know you got it sorted out. Allan

Thank you both!. We solved yesterday creating a proxy PHP in our side and here the code with all the params (after a couple of hours we learned that "processData": false is needed to receive the POST objects as it is in PHP . "ajax": function (method, url, data, successCallback, errorCallback) { $.ajax( { "type": "POST", "url" : "../datasource/execute_action.php", "data": JSON.stringify(data), "contentType" : "application/json", "dataType": 'json', "processData": false, "cache": false, "success": function (json) { //successCallback( json ); }, "error": function (xhr, error, thrown) { //errorCallback( xhr, error, thrown ); } } );

It wraps everything in "d"?! That's a bit odd and could be fairly annoying I guess. However, your method of dealing with it looks sensible to me :-) Allan

Thanks, this is exactly what I need :)

I reply and I haven't seen your comment after, thanks a lot. Datatables plugin is awesome. :D