Hello,
I have two tables with profiles data and plus IMG or minus IMG in each line, the first table have profiles that the current person has, and the second table have profiles that he doesn't has.
So when i click on the - IMG it was supposed to remove current line from the first table and add it in the second table, and when I click in the + IMG it should remove current line from the second table and add it in the first table.
I've made it before but i was not using server-side processing, when I click the page save button it will get the tables data and save it in the DataBase, so the modified data are "temporary", in other words, they can be canceled, it's why I don't want to access the DB before clicking save button...

I was using fnAddData and fnDeleteRow to do that, but it doesn't work with server-side processing, is there another way to do that?
Maybe some way to use server processing to load the tables in the first time then deactivate it and use array method...

First table
[code]

//-----------------------
//grid1

oTable = $('#grid').dataTable({
"oLanguage": { "sUrl": "media/language/pt-br2.txt" },
"bJQueryUI": false,
"sPaginationType": "full_numbers",
"iDisplayLength": 10,
"bProcessing": false,
"bServerSide": true,
"sAjaxSource": "server_processing_perfis_selecionados.php",
"fnServerData": function ( sSource, aoData, fnCallback ) {
<?
print 'aoData.push( { "name": "conjunto", "value": $("#conjunto").val() } );';
?>
$.ajax({
"dataType": 'json',
"typ$e": "GET",
<?
print '"url": "server_processing_perfis_selecionados.php", ';
?>
"data": aoData,
"success": fnCallback,
});
},

"bAutoWidth": false,
"bLengthChange": true,
"sDom": '<"top"f<"clear">ip<"clear">> <"bottom"t>', /* "fnRowCallback" : function(nRow, aData, iDisplayIndex){
$("td:first", nRow).html(iDisplayIndex +1);
return nRow;
},*/
"aoColumns": [
{ "sTitle": "PERFIL", "sWidth": "60%", "bSortable": true, "bVisible": true },
{ "sTitle": "IDLOGIN" , "sWidth": "20%", "bSortable": true, "bVisible": true },
{"sTitle": "REMOVER" , "sWidth": "20%","sClass": "center", "bSortable": false, "bVisible": true,
"sName" : "REMOVER" , "bUseRendered": false, "fnRender": function (oObj) {
return '';
}
}
],
"aaSorting": [[ 0, 'asc' ]]
});

// delete it from the first table and add it in the second table;
$('#grid tbody td img').live('click', function () {
var row = this.parentNode.parentNode;
oTable2.fnAddData(oTable.fnGetData(row));
oTable.fnDeleteRow(row);
});

[/code]


Second table
[code]

//grid 2
oTable2 = $('#grid2').dataTable({
"oLanguage": { "sUrl": "media/language/pt-br2.txt" },
"bJQueryUI": false,
"sPaginationType": "full_numbers",
"iDisplayLength": 10,
"bProcessing": false,
"bServerSide": true,
"sAjaxSource": "server_processing_perfis_todos.php",
"fnServerData": function ( sSource, aoData, fnCallback ) {
<?
print 'aoData.push( { "name": "conjuntoperfil", "value": $("#conjuntoperfil").val() } );';
?>
//aoData.push( { "name": "min", "value": $('#min').val() } );
//aoData.push( { "name": "max", "value": $('#max').val() } );
$.ajax({
"dataType": 'json',
"typ$e": "GET",
<?
print '"url": "server_processing_perfis_todos.php", ';
?>
"data": aoData,
"success": fnCallback
});
},

"bAutoWidth": false,
"bLengthChange": true,
"sDom": '<"top"f<"clear">ip<"clear">> <"bottom"t>', /* "fnRowCallback" : function(nRow, aData, iDisplayIndex){
$("td:first", nRow).html(iDisplayIndex +1);
return nRow;
},*/
"aoColumns": [
{ "sTitle": "PERFIL", "sWidth": "80%", "bSortable": true, "bVisible": true },
{ "sTitle": "IDLOGIN" , "sWidth": "20%", "bSortable": true, "bVisible": true },
{"sTitle": "REMOVER" , "sWidth": "20%","sClass": "center", "bSortable": false, "bVisible": true,
"sName" : "REMOVER" , "bUseRendered": false, "fnRender": function (oObj) {
return '';
}
}
],
"aaSorting": [[ 0, 'asc' ]]
});

// delete it from the second table and add it in the first table;
$('#grid2 tbody td img').live('click', function () {
var row = this.parentNode.parentNode;
oTable.fnAddData(oTable2.fnGetData(row));
oTable2.fnDeleteRow(row);
});
[/code]

Thanks and regards,
Fabricio