Stored Procedure only returning results for the first row of a table.

posted on March 3, 2016 • Show version history

Hi all,

I have a stored procedure that brings in data within a table. It works great for the first row, but if the user adds another row the procedure is not bringing in any data. Any idea why this is? My code so far is below:

css:

.autofill {display: none;}

JavaScript:

$(document).ready(function () {
  
   function autofill() {
    $('.autofill').trigger('click');
  } 
  
  $('.lookupCondition').change(autofill);
  
});

I included these because the procedure wasn't running unless the auto fill button was pressed. This hides the auto fill button and, at least for the first row of the table, runs the procedure.

Any idea how to get this procedure to return results for all rows of the table?

0 0

posted on March 3, 2016

Your javascript creates an event handler for elements that have the ".lookupCondition" class to respond to change events when the page is finished loading. If you then add a new row to the table, it will NOT trigger this event handler because it wasn't on the page when the HTML was loaded. What you need is a delegated version of the event handler. You can read more about this in at the following section of the jQuery documentation for the .on() function. https://api.jquery.com/on/#direct-and-delegated-events

Here is some sample code that would probably work the way you are expecting:

$(document).ready(function(){
   $(".ObjectiveTable").on("change",".lookupCondition input", function(){
      $(this).closest("tr").find(".autofill").trigger("click");
   });
})

You may need to adjust a bit. Note that you will need to use the closest() function and the find() function to be sure you are clicking on the autofill button in the correct row.

4 0

replied on March 3, 2016 • Show version history

Scott,

This works fantastic! Thank you so much for the help. Can you help with one more thing? How would I implement this logic:

If #q5 input (css class relabel) = RLBL make #q19 input (css class rlblcheck) blank ("").

Thanks

0 0

replied on March 4, 2016

$(".relabel input').on('change',function(){
   if ($(this).val()=="RLBL") $(".rlblcheck input").val(""); // Replace this with $(".rlblcheck input").prop('checked',false); if it is a checkbox
});

0 0

Discussion

Discussion

Stored Procedure only returning results for the first row of a table.

Comments 0

Follow-Ups 1

Discussion 1

Sign in to reply to this post.