Datatable keeps sending request to the server and not show the result

Datatable keeps sending request to the server and not show the result

alidadalidad Posts: 1Questions: 0Answers: 0
edited August 2011 in General
I am using datatable and it works perfectly in FF, in IE8 if I render the table for the first time it works fine but, when it triggered the render again for any reason (new search criteria, sort, etc.) it starts sending multiple request to the server and finally wont show the result.
There is no error or anything but the processing indicator stays on and sends usually 3 requests to server(action). I looked at the params in the request and sechos is different and couple more.


this is my code
[code]
var oTable = $('#report').dataTable({
"bJQueryUI": true,
"sScrollY": '50%',
sScrollX: '800',
"aaSorting": [[ 1, "asc" ]],

bProcessing: true,
bServerSide: true,
sAjaxSource: '${request.contextPath + '/dailyPositionComparison/update'+'?time='+ session.requestId}' ,
bJQueryUI: true,
sPaginationType: "full_numbers",
aLengthMenu: [[10,20, 50, 100, 500, -1], [10,20, 50, 100, 500, "All"]],
iDisplayLength: 10,
"sDom": 'T<"clear">pfrtli',
"oTableTools": {

"sSwfPath": "../css/tabletools/swf/copy_cvs_xls_pdf.swf",
"aButtons": [
{
"sExtends": "collection",
"sButtonText": "Export",
"aButtons": [
{
"sExtends": "text" ,
"sButtonText": "Save XLS",
"fnClick": function () {
post_to_url('${request.contextPath + '/dailyPositionComparison/exportToExcel'}', '', 'GET')
}
},
{
"sExtends": "csv" ,
"sButtonText": "Save CSV"
},
{"sExtends": "pdf","sPdfOrientation": "landscape"} ]
}
]
}
});
[/code]


[code]
["mDataProp_2":"2", "mDataProp_5":"5", "bRegex_14":"false", "bSortable_10":"true", "bSortable_3":"true", "time":"1314308391943", "bRegex_5":"false", "bRegex_2":"false", "
iDisplayLength":"10", "mDataProp_7":"7", "iColumns":"15", "_":"1314308426819", "sSearch_12":"", "bSearchable_10":"true", "bSearchable_8":"true", "sSortDir_0":"asc", "mDat
aProp_6":"6", "sEcho":"3", "sSearch":"", "sSearch_0":"", "iDisplayStart":"0", "bSortable_1":"true", "iSortingCols":"1", "sSearch_13":"", "mDataProp_0":"0", "bSearchable_6
":"true", "sSearch_1":"", "bSortable_13":"true", "sSearch_14":"", "mDataProp_14":"14", "bSearchable_12":"true", "bSearchable_7":"true", "sSearch_2":"", "bSortable_14":"tr
ue", "bSearchable_13":"true", "sSearch_11":"", "sSearch_5":"", "bSearchable_4":"true", "bRegex_6":"false", "bRegex_9":"false", "bRegex_13":"false", "sSearch_8":"", "bRege
x":"false", "mDataProp_4":"4", "sSearch_4":"", "bSortable_7":"true", "mDataProp_12":"12", "sSearch_7":"", "bSearchable_0":"true", "sSearch_10":"", "sSearch_6":"", "bSearc
hable_1":"true", "bSortable_0":"true", "bRegex_4":"false", "bRegex_11":"false", "bSortable_9":"true", "sSearch_9":"", "sSearch_3":"", "bSortable_2":"true", "bSearchable_3
":"true", "mDataProp_13":"13", "bSortable_6":"true", "bSearchable_5":"true", "bSortable_12":"true", "bRegex_0":"false", "bRegex_7":"false", "mDataProp_11":"11", "bSortabl
e_4":"true", "mDataProp_1":"1", "bRegex_10":"false", "action":"update", "iSortCol_0":"0", "sColumns":"", "mDataProp_8":"8", "bRegex_8":"false", "mDataProp_10":"10", "bSea
rchable_14":"true", "controller":"dailyPositionComparison", "mDataProp_3":"3", "bSortable_11":"true", "bRegex_1":"false", "bSearchable_9":"true", "bRegex_3":"false", "bRe
gex_12":"false", "bSortable_5":"true", "bSearchable_11":"true", "bSearchable_2":"true", "bSortable_8":"true", "mDataProp_9":"9"]
[/code]
second request
[code]
["mDataProp_2":"2", "mDataProp_5":"5", "bRegex_14":"false", "bSortable_10":"true", "bSortable_3":"true", "time":"1314308391943", "bRegex_2":"false", "bRegex_5":"false", "
iDisplayLength":"10", "mDataProp_7":"7", "iColumns":"15", "_":"1314308426662", "sSearch_12":"", "bSearchable_10":"true", "bSearchable_8":"true", "sSortDir_0":"asc", "mDat
aProp_6":"6", "sEcho":"2", "sSearch":"", "sSearch_0":"", "iDisplayStart":"0", "bSortable_1":"true", "iSortingCols":"1", "sSearch_13":"", "mDataProp_0":"0", "bSearchable_6
":"true", "sSearch_1":"", "bSortable_13":"true", "sSearch_14":"", "mDataProp_14":"14", "bSearchable_12":"true", "bSearchable_7":"true", "sSearch_2":"", "bSortable_14":"tr
ue", "bSearchable_13":"true", "sSearch_11":"", "sSearch_5":"", "bRegex_6":"false", "bSearchable_4":"true", "bRegex_9":"false", "bRegex_13":"false", "sSearch_8":"", "bRege
x":"false", "mDataProp_4":"4", "sSearch_4":"", "bSortable_7":"true", "mDataProp_12":"12", "sSearch_7":"", "bSearchable_0":"true", "sSearch_10":"", "bSearchable_1":"true",
"sSearch_6":"", "bSortable_0":"true", "bRegex_4":"false", "bRegex_11":"false", "bSortable_9":"true", "sSearch_9":"", "sSearch_3":"", "bSortable_2":"true", "mDataProp_13"
:"13", "bSearchable_3":"true", "bSortable_6":"true", "bSearchable_5":"true", "bSortable_12":"true", "bRegex_0":"false", "bRegex_7":"false", "mDataProp_11":"11", "bSortabl
e_4":"true", "mDataProp_1":"1", "bRegex_10":"false", "action":"update", "iSortCol_0":"0", "sColumns":"", "mDataProp_8":"8", "bRegex_8":"false", "mDataProp_10":"10", "bSea
rchable_14":"true", "controller":"dailyPositionComparison", "mDataProp_3":"3", "bSortable_11":"true", "bRegex_1":"false", "bSearchable_9":"true", "bRegex_3":"false", "bRe
gex_12":"false", "bSortable_5":"true", "bSearchable_11":"true", "bSearchable_2":"true", "bSortable_8":"true", "mDataProp_9":"9"]
[/code]
This discussion has been closed.