Replies

• nikki Posts: 5Questions: 0Answers: 0

  January 2012

  Figured this out, will post an answer tomorrow.
• nikki Posts: 5Questions: 0Answers: 0

  January 2012

  When the string was returned from the asmx web service, it was wrapped in double quotes and then wrapped inside the d object. The d object was being read as a object, but every level underneath was seen as one large string. This extra double quote wrapping was not allowing datatables.net to read the return data as an object, instead it read as a string. Since it was a string, when Datatables attempted parsing the data by checking the length iTotalRecords or any other item, it was undefined and could not find the length.
  
  This is the final ajax call that worked, had to use $.evalJson on the d object, then send the result of this into the fnCallback .
  
  [code]
  $("#selectProgram").dataTable({
  "bPaginate": true,
  "bProcessing": true,
  "bServerSide": true,
  "sAjaxSource": "GetPending.asmx/GetDataTablesLoad",
  "sPaginationType": "full_numbers",
  "aaSorting": [[1, 'asc']],
  "fnServerData": function (sSource, aoData, fnCallback) {
  $.ajax({
  "dataType": 'json',
  "contentType": "application/json; charset=utf-8",
  "type": "GET",
  "url": sSource,
  "data": aoData,
  "success":
  function (msg) {
  var json = $.evalJSON(msg.d);
  fnCallback(json);
  }
  });
  }
  });
  
  [/code]
• allan Posts: 63,397Questions: 1Answers: 10,451 Site admin

  January 2012

  It looks to me that the "JSON" returned from the server isn't really JSON, but rather a string - hence why it needs to be eval'ed twice - once by jQuery and once yourself. Actually - more accurately the object DataTables is looking for is a string - i.e.:
  
  [code]
  {
  "d": string....
  }
  [/code]
  
  If you could just pass back the "inner" object (i.e. the value of 'd') as an object rather than a string, that would do it nicely without any need for fnServerData.
  
  Allan
• nikki Posts: 5Questions: 0Answers: 0

  January 2012

  Allen, thanks for the reply, so i wouldnt even need to use the fnSererData? Just put the service name in the sAjaxSource and return an object? Nice! I'll have to give that a shot.
• allan Posts: 63,397Questions: 1Answers: 10,451 Site admin

  January 2012

  Yup - exactly that :-)
  
  Allan