Databases
StackOverflow2013
Postsdbo
POExample using attr()
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExample using attr()
    primarykey
    data
    text
    <p>Following this question - <a href="https://stackoverflow.com/questions/6985899/extending-clone-table-rows-functionality-changing-row-id">Extending Clone Table Rows functionality - changing row ID</a></p> <p>The code - <a href="http://jsfiddle.net/EwQUW/58/" rel="nofollow noreferrer">http://jsfiddle.net/EwQUW/58/</a></p> <p>I want to update the attr. Please check the code and I have included comments to see what I am talking about.</p> <p><strong>EDIT</strong></p> <pre><code>&lt;table id="table"&gt; &lt;tbody&gt; &lt;tr&gt; &lt;td&gt; &lt;select name="make[]" id="make" onchange="change(this,'model')"&gt; &lt;option value="" selected=“selected”&gt; Please Select &lt;/option&gt; &lt;option value=Ford&gt; Ford&lt;/option&gt; &lt;option value=Nissan&gt; Nissan&lt;/option&gt; &lt;option value=Volvo&gt; Volvo&lt;/option&gt; &lt;option value=BMW&gt; BMW&lt;/option&gt; &lt;/select&gt; &lt;/td&gt; &lt;td&gt; &lt;select name="model[]" id="model" onchange="change(this,'make')"&gt; &lt;option value="" selected=“selected”&gt; Please Select &lt;/option&gt; &lt;option value=Ford&gt; Fiesta&lt;/option&gt; &lt;option value=Nissan&gt; Mirca&lt;/option&gt; &lt;option value=Volvo&gt; s60&lt;/option&gt; &lt;option value=BMW&gt; M3&lt;/option&gt; &lt;/select&gt; &lt;/td&gt; &lt;td&gt; &lt;input id="country" name="country[]"/&gt; &lt;/td&gt; &lt;td&gt; &lt;input id="city" name="city[]" /&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/tbody&gt; &lt;/table&gt; &lt;button id="add"&gt;Add&lt;/button&gt; </code></pre> <p>Javascript</p> <pre><code>function change(fld,id) { var opt = fld.selectedIndex; if (fld[opt].value != ' ') { var sel = document.getElementById(id); for (var i = sel.options.length -1; i &gt; -1; i--) { if (fld[opt].value == sel[i].value) sel[i].selected = true; } } } </code></pre> <p>When I add a new row, I want the ID, NAME and onchange to be updated with a count or length as you put. </p> <p>As ID are updated and onchange to id=make to id=make2 so the onchange still works</p> <p><strong>EDIT AGAIN</strong></p> <p>Actually names will be an array. So only IDS and Onchange needs updating depending on number of rows</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USLandY
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COMay I offer a less complex method: [JS Fiddle demo](http://jsfiddle.net/davidThomas/ef3eg/1/).
      singulars
      1. POExample using attr()
      1. USDavid Thomas
    2. COdoes this change the id when the rows are cloned? Could I add find("input,select") in?
      singulars
      1. POExample using attr()
      1. USLandY
    3. COYes. If you're using a web browser with a JavaScript console (Chrome/Chromium/Safari have Web Inspector, Opera has Dragonfly, Firefox has Firebug, IE has...something?), you should be able to right-click the cloned rows/elements and select 'inspect element.' This will show the element in the DOM. I did however forget to update the demo link to a working version: [JS Fiddle](http://jsfiddle.net/davidThomas/ef3eg/2/).
      singulars
      1. POExample using attr()
      1. USDavid Thomas
 

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