DataTable + DataFilter + DOM

rodrigo2906

I'm trying to get the data from the datatable to persist on the db.

I'm populating the table using jquery template and it's working fine.

My table:
[code]



Modify
Currency
Rate
New Rate




[/code]

Template:
[code]
$('#_spotRatesTemplate').tmpl(_spotRates).appendTo("#tSpotRatesBody");
[/code]

My datatable:
[code]
spotRatesTable =
$('#tSpotRates').dataTable({ "bSort": false, "sPaginationType": "full_numbers","sDom":'<"top"p l>rt<"clear">'})
.columnFilter({sPlaceHolder: "head:before",aoColumns: [null, { type: "select" },null,null]});
[/code]

I also tried populating the datatable with a ajax call :
[code]
spotRatesTable = $('#tSpotRates').dataTable({
"bSort": false,
"sPaginationType": "full_numbers",
"sDom":'<"top"p l>rt<"clear">',
"aoColumns":[
{"mDataProp": null},
{"mDataProp": "currency"},
{"mDataProp": "spotRate"},
{"mDataProp": "newRate"},
],
"sAjaxSource":"/fxtrm/app/utilities/simulator/spotRates",
}).columnFilter({sPlaceHolder: "head:before",aoColumns: [null, { type: "select" },null,null]});
[/code]

I'm able to edit the table and update it's values using fnUpdate without any problem.

How can I POST the content of the datatable?
I tried to use $('#tSpotRates').serialize() but it returns nothing but the table length.

Please help