Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Looks like you're getting tripped up by using the class selectors on your containing <code>div</code> tags.</p> <p>Specifically, the goal of <code>var child</code> is to return an array of <code>option</code> tags. Ideally, you should use the <code>ID</code> attribute the form builder assigns to each element. Not knowing how you opened your form (ie. not knowing the parent model), let's assume your open statement looks something like:</p> <pre><code>&lt;%= form_for @product_batch do |f| %&gt; </code></pre> <p>This will make your <code>product</code> and <code> batch_no</code> select fields look something like:</p> <pre><code>&lt;select name="product_batch[product_id]" id="product_batch_product_id"&gt; &lt;select name="product_batch[batch_no]" id="product_batch_batch_no"&gt; </code></pre> <p>Now, we can refactor your jQuery as follows:</p> <pre><code>jQuery(function() { var child = $('#product_batch_batch_no').html(); $('#product_batch_product_id').live("change", function() { var escaped_parent, parent, options; parent = $('#product_batch_product_id :selected').text(); escaped_parent = parent.replace(/([ #;&amp;,.+*~\':"!^$[\]()=&gt;|\/@])/g, '\\$1'); options = $(child).filter("optgroup[label='" + escaped_parent + "']").html(); $('#product_batch_batch_no').html(options); }); }); </code></pre> <p>The last bit of the your code:</p> <pre><code>if (options) { jQuery('.batch').html(options); return jQuery('.batch').parent().show(); } else { jQuery('.batch').empty(); } </code></pre> <p>is literally destructive. When a product does not have a <code>batch_nojQuery('.batch').empty();</code> removes the html inside: </p> <pre><code>&lt;div class="batch"&gt;&lt;/div&gt; </code></pre> <p>Once removed, this code is gone...which is probably not what you want.</p> <p>Anyway, I agree with Ryan Bates' opinion that this is a great, unobtrusive way to implement dynamic select boxes. You may want to checkout the revised RailsCast at <a href="http://railscasts.com/episodes/88-dynamic-select-menus-revised" rel="nofollow">http://railscasts.com/episodes/88-dynamic-select-menus-revised</a></p> <p>Best of luck!</p>
    singulars
    1. This table or related slice is empty.
    1. PODynamic select in ruby on rails using jquery
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USjrmyward
    1. USjrmyward
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks...yeah i did this with help of revised rails cast...was getting stuck... and in code i think its `escaped_parent` rite?? instead of `escaped_stat`?? :)
      singulars
      1. PO
      1. USbharath
    2. COYou're right...changed in my answer :)
      singulars
      1. PO
      1. USjrmyward
 

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