Replies

• allan Posts: 63,381Questions: 1Answers: 10,449 Site admin

  March 2014

  Set the mData option for your second column to `null` , just like you have for the first column. That will deal with it.
  
  Allan
• leeguth Posts: 19Questions: 1Answers: 0

  March 2014

  Thanks that worked!!! I didn't realize I needed both :)
• allan Posts: 63,381Questions: 1Answers: 10,449 Site admin

  March 2014

  mData will default to the column index if it isn't given - which is why you were getting an error about the data at index `1` missing.
  
  Allan
• leeguth Posts: 19Questions: 1Answers: 0

  March 2014

  Further question on mRender.....do you know if within the function for setting the value, I can make another ajax call? I am trying it but keep getting an error in dataTable - I get the same error I had above, plus I get a similar one for 'row 2' and I get null for the datatable column where I do seem to be getting something back from the ajax call.
  
  for example: (I blanked on most of the url below because it was company specific and this is only a small portion of the code) The value of 'burl' is correct because i can take out the ajax call and output the value, just seems when i do the ajax call that it is causing the error.
  
  { "mData": null,
  "mRender": function(data,display, row) {
  var burl = "https://...../beta/"+row.prg_guid;
  $.ajax({
  url:burl,
  success:function(data2){
  if (data2 == "green"){
  return "";
  }
  }
  }
  ]
  } );
  }
  } );
  }
  
  Would you have any suggestions of a different way to do this, if I can't have the ajax call in the mRender?
• allan Posts: 63,381Questions: 1Answers: 10,449 Site admin

  March 2014

  > I can make another ajax call?
  
  Yes, but remember what the first letter of Ajax stands for: _asynchronous_. mRender is executed synchronously, and expects the data back as such. But your Ajax is completing after that. You could make it Sjax, but that will _kill_ performance.
  
  You'd be much better trying to get all the data you need into the data structure.
  
  Allan
• leeguth Posts: 19Questions: 1Answers: 0

  March 2014

  hmmmm....ok. thanks!
• leeguth Posts: 19Questions: 1Answers: 0

  March 2014

  Allan,
  I've been wondering on my issue of needing to call a function (that requires an ajx call) to fill in a value....Could I give the cell a sName and a value of null. Then use a .each call on the success of the ajax call to loop through each table row and update the particular cell (column) with the value?
  
  I saw the documentation for fnUpdate and wasn't sure if that could be what I could use. I couldn't tell by the example though if I could use it that way or exactly how I would go about it.
  
  You documentation example shows the code below....and seems to allow updating a cell at a time.
  $(document).ready(function() {
  var oTable = $('#example').dataTable();
  oTable.fnUpdate( 'Example update', 0, 0 ); // Single cell
  oTable.fnUpdate( ['a', 'b', 'c', 'd', 'e'], 1 ); // Row
  } );
  
  Can I call the single cell example in conjunction with the each? If so, the two zeroes shown....would I need to change that to 'row' reference somehow? And can I reference the cell by the name I give it or do I need to provide a number there?
• allan Posts: 63,381Questions: 1Answers: 10,449 Site admin

  March 2014

  Yes, that would be one way of doing it (use an empty string, not null though).
  
  You might find it easier to understand using the new API in DataTables 1.10 - http://next.datatables.net/reference/api/cell().data() (I need to update the forum linking - you need to add the `()` at the end manually - sorry.
  
  Allan