Answers

• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  July 2016

  but it goes back to the first entry of the current page

  When you call draw() pass in false to stop DataTables resetting the paging: table.draw( false ); for example. The draw() reference page has some more details and explains the other options available as well.

  Allan
• DaveMorton Posts: 6Questions: 1Answers: 0

  July 2016

  See? I thought I had missed something! Thanks, Allan!
• DaveMorton Posts: 6Questions: 1Answers: 0

  July 2016

  Sadly, I must report that the behavior has not changed. Here is the function where I'm experiencing the problem:

  function saveEdit(ele) {
    var rowID = ele.attr('data-rowID');
    var fieldName = ele.attr('data-fieldName');
  
    // insert the new value into the current cell
    var curVal = ele.val();
    ele.parent().text(curVal);
  
    // set variables for the AJAX call
    var row = $('#' + rowID);
    var bot_id = row.find('.bot_id').text();
    var pattern = row.find('.pattern').text();
    var template_id = row.find('.template_id').text();
  
    // Now gather all of the fields and send the updated information
    $.ajax({
      url: 'editSRAI.php',
      type: 'post',
      dataType: 'text',
      data: {
        action: 'update',
        id: rowID,
        bot_id: bot_id,
        pattern: pattern,
        template_id: template_id,
      },
      success: function(data) {
        $('#errMsg').empty().html('<div class="closeButton" id="closeButton" onclick="closeStatus(\'errMsg\')" title="Click to hide">&nbsp;</div>').show();
        $('<pre>').html(data).appendTo('#errMsg');
        setTimeout(hideMsg, 3000);
        table.draw(false);
      }
    });
  }
  

  Every action taken in this function except the table being redrawn "in place" works as it should. The table still redraws from the beginning of the current page, thus causing it to display from the first entry, instead of the last edited one. It should be noted that if I comment out the line table.draw(false), the page behaves visually as it should, but the data isn't really being updated from the DB. It's just getting "swapped in" by the function (e.g. ele.parent().text(curVal)). This is fine, if need be, but I would much rather have the data updated from the DB, as a form of verification.

  If need be I can privately provide a link and a temporary login so that the behavior can be observed first-hand. I cannot, however, post a link publicly, for security reasons.
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  July 2016

  Yes please - links are always welcome. I'd need to be able to see the initialisation and probably walk through the code.

  Allan
• DaveMorton Posts: 6Questions: 1Answers: 0

  July 2016

  I've sent you an email with the pertinent information. Please let me know if you have any questions/difficulties. Thanks for taking the time to look at it.
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  July 2016

  Hi,

  I've finally had a little chance to look at this (sorry for the delay!) and the editAiml.js script currently uses draw() without passing any parameters to it:

                  success: function(data) {
                    $('#errMsg').empty().html('<div class="closeButton" id="closeButton" onclick="closeStatus(\'errMsg\')" title="Click to hide">&nbsp;</div>').show();
                    $('<pre>').html(data).appendTo('#errMsg');
                    console.log('Foo!');
                    setTimeout(hideMsg, 3000);
                    table.draw();
                  }
  

  Could you update that script there to use table.draw(false); and I can try debugging it from that point?

  Thanks,
  Allan
• DaveMorton Posts: 6Questions: 1Answers: 0

  July 2016

  Sure. It's been done.
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  September 2016

  This one slipped me by - sorry! Are you still having problems with this?
• DaveMorton Posts: 6Questions: 1Answers: 0

  September 2016

  Yes I am, as a matter of fact. Changing the draw() calls to draw(false) seems to have no effect on the issue.