Datatables - serverside proceccing - not working in IE7

kyenneti

I am trying datatables server_side processing - Its working great in firefox but not working in IE-7.
I tried both 1.5.beta.7 and 1.5.beta.8 .I am getting the following for the totals -I had total of 20 records.

Showing 1 to 0 of 20 entries ( on IE)
Showing 1 to 10 of 20 entries ( on firefox)

allan

Hi kyenneti,

The most likely think here is that you have a trailing comma at the end of your data array. Firefox allows for this, while IE (I would say correctly in this regard, and I don't say that about IE often :-) ) does not and throws an error.

Try passing your JSON return through www.jsonlint.com - a fantastic validator for JSON.

Regards,
Allan

kyenneti

Thank you so much..That fixed it. I checked my return through firebug (another great utility like yours ) - My Output final field had a comma at the end.
Again.Thank you for your plugin and support-
Kalyan

cmanva

I have the same issue, but the trailing comma is removed and my JSON data is valid. But when I run it on IE7, the screen is blank? It works great on Chrome and firefox. Any tips on what to look for?

Note: classic asp

code to strip:
[code]
if len(aaData) > 0 then
aaData = Left(aaData,Len(aaData)-1)
end if
[/code]


JSON data:
[code]
{
"sEcho": 1,
"iTotalRecords": 1,
"iTotalDisplayRecords": 1,
"aaData": [
[
"Towers Perrin and Watson Wyatt Complete Merger to Form Towers Watson Towers Watson & Co. announced today the completion of the merger of Towers Perrin and Watson Wyatt. The transaction to form Towers Watson, a leading global professional services company, was announced on June 28, 2009. Watson Wyatt Chief Executive Officer John Haley will serve as Towers Watson’s Chairman and Chief Executive Officer; Towers Perrin Chief Executive Officer Mark Mactas will serve as Deputy Chairman, President and Chief Operating Officer.",
"January 03, 2010|GlobalShare|"
]
]
}
[/code]

cmanva

Also, is there way to throw an alert message based on success or failure? Can anyone help with syntax?

allan

Your JSON is not valid: http://jsonlint.com/ . There is an unescaped quote which is causing the problem. DataTables 1.7+ will give an alert() to indicate this.

Allan

cmanva

I reformatted the JSON data, still getting the same issue? But, I noticed that something is getting pushed to the screen, but blank (footer getting pushed down the screen based on size of records returned)?
Note:
I'm getting this data from Chrome (XHR developer tools) and pasting it to http://www.jsonlint.com/ on an IE7 browser. Not sure if there's anything on the IE end to troubleshoot this?

[code]
{
"sEcho": 1,
"iTotalRecords": 1,
"iTotalDisplayRecords": 1,
"aaData": [
[
"Towers Perrin and Watson Wyatt Complete Merger \r\nto Form Towers Watson\r\nTowers Watson & Co. announced today the completion of the merger of Towers Perrin and Watson Wyatt. The transaction to form Towers Watson, a leading global professional services company, was announced on June 28, 2009. Watson Wyatt Chief Executive Officer John Haley will serve as Towers Watson’s Chairman and Chief Executive Officer; Towers Perrin Chief Executive Officer Mark Mactas will serve as Deputy Chairman, President and Chief Operating Officer.",
"January 03, 2010|GlobalShare|"
]
]
}
[/code]

cmanva

I figured it out..my javascript on the client side..I needed to remove a comma after my last parameter.