Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Please let me know if I'm misunderstanding the question, but I think I've dealt with something similar.</p> <p>Browsers all handle the change event differently and usually doesn't fire until the user clicks away from that field after updating it (by clicking somewhere else on the page and solidifying their change).</p> <p>My workaround has been to create a function that does the work for me and have that function run on click instead of change. To cover your bases (and not have dynamic data loading unnecessarily), I would go about it this way:</p> <ol> <li>Create global variables or object to track the state of each dropdown (you can store id, value, etc. - this basically alows you to check whether the dropdown. For default state, create all the variables and set their values to blank)</li> <li>Create a function that runs each time any of the fields are clicked and pass in the dropdown (either through ID, name or the actual jQuery object)</li> </ol> <p><strong>The JavaScript Portion</strong> </p> <pre><code>$(document).ready(function() { // Attach click function to princ $("select[name='princ']").click(function() { var value = $(this).val(); // Grab the value if (value != demo.globals.princ) { // Check if the value is the old value demo.checkDropdown('princ', 'princ2', value); // If it's a new value, grab the selected value and run the checkDropdown function demo.globals.princ = value; // Set the global value $('#status').text("loading new values for princ " + value); } else { $('#status').text("princ values already loaded " + value); // Unnecessary but used to output the status of the clicks } }); // Attach click function to princ2 $("select[name='princ2']").click(function() { var value = $(this).val(); if (value != demo.globals.princ2) { demo.checkDropdown('princ2', 'princ3', value); demo.globals.princ2 = value; $('#status').text("loading new values for princ2 " + value); } else { $('#status').text("princ2 values already loaded " + value); } }); }); // Create a global object to avoid function collision var demo = {}; // Create global variables demo.globals = { princ: 0, princ2: 0 } // Dropdown population function demo.checkDropdown = function(dropDownName, nextDropDown, value) { // Check if it's already populated with the correct data, otherwise load it // You can also load dynamic data here via AJAX and update the select field var dropDownHtml = "&lt;option value='1'&gt;1&lt;/option&gt;"; dropDownHtml += "&lt;option value='2'&gt;2&lt;/option&gt;"; dropDownHtml += "&lt;option value='3'&gt;3&lt;/option&gt;"; $("select[name='" + nextDropDown + "']").html(dropDownHtml); } </code></pre> <p><strong>The HTML</strong> </p> <pre class="lang-html prettyprint-override"><code>&lt;body&gt; &lt;form&gt; &lt;div id="status"&gt;Page loaded&lt;/div&gt; &lt;select name="princ"&gt; &lt;option value="0"&gt;Please select one&lt;/option&gt; &lt;option value="1"&gt;1&lt;/option&gt; &lt;option value="2"&gt;2&lt;/option&gt; &lt;option value="3"&gt;3&lt;/option&gt; &lt;/select&gt; &lt;select name="princ2"&gt; &lt;/select&gt; &lt;select name="princ3"&gt; &lt;/select&gt; &lt;/form&gt; &lt;/body&gt; </code></pre> <p>I really hope this helps you out. It's a little more than what you're asking for, but it is a complete, working example of how to get dropdown values on change.</p>
    singulars
    1. This table or related slice is empty.
    1. POjQuery can't fire 'change' event using code to mimmic list selection change
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USStephan Robberts
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POjQuery can't fire 'change' event using code to mimmic list selection change
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks Stephan, I'll give it a try!
      singulars
      1. PO
      1. USuser1494526
    2. COStephan, I've been trying to implement this code, however, it only runs the first time, i.e., it runs the first list and shows the second one, but it doens't run the second itself: it simply doesn't show the third list. This is also evident because the test messages only show when clicking the first list ("loading new values" and "values already loaded"). I used the same code you're showing and adapted it to my needs. Placed it after the html code. Also changed the "demo" declaration to the top of the js code so variables could be recognized by click and showlist functions. Any ideas?
      singulars
      1. PO
      1. USuser1494526
    3. COWell, just fount out that for some reason the "select[name='XXXX']" statements were not working, so I had to write (until now, will solve this issue later) separate dropdown functions for each id ('#princ', '#princ2'...). Now the lists are working properly, showing what they're supposed to show, BUT for some reason list No.2 (princ2) is not passing its value, but I can get the values from "princ" and "princ3, weird behaviour, have revised the code in depth but found nothing out of the ordinary so far... will keep looking...
      singulars
      1. PO
      1. USuser1494526
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload