Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>First of all, store your rows in an array as well, your ROW1 - ROW4 are going to give you headaches.</p> <pre><code>var ROWS = [ ['module1'], ['module4', 'module2'], ['module5'], ['module7', 'module3', 'module8'] ]; </code></pre> <p>You also want a way to remove an element. <a href="http://wolfram.kriesing.de/blog/index.php/2008/javascript-remove-element-from-array" rel="nofollow noreferrer"><code>.splice()</code></a> is built into arrays, and works great to remove elements.</p> <pre><code>// lets clear out our disabled modules var disabledModules = ['module3', 'module5']; // quick sample function - yours might check for empty content or whatever else... function isDisabled(module) { for (var i=0, test; test=disabledModules[i]; i++) { if (test === module) return true; } return false; } for(var i=0,row; row=ROWS[i]; i++) { for (var j=0,module; module=row[j]; j++) { // is this module in our disabled modules list? if (isDisabled(module)) { // the module is disabled row.splice(j,1); j--; // so we recheck this point in the array } } if (row.length &lt; 1) { // all items were deleted ROWS.splice(i,1); i--; // so we recheck this point.. } } // ROWS === [["module1"], ["module4", "module2"], ["module7", "module8"]] </code></pre> <p>Your comment asked about the for loop syntax used. It's a pretty quick way to loop through arrays you know won't have "false" values. Breaking one apart and turning on verbose logging:</p> <pre><code> for( // Part 1 of for loop: Setup, create two variables, i=0, and row. var i=0,row; // Part 2: The test - when false, loop will exit, gets executed pre-loop every time // Assignment operator returns the value assigned, so row=ROWS[i] will be undefined // (false) when we reach then end of the array. row=ROWS[i]; // Part 3: Post loop - increment i i++) { </code></pre> <p>The dangers of using this method do exist though, if its an array of numbers for instance, and one of those numbers is 0, the loop will exit early. The alternative would be to write:</p> <pre><code>for(var i=0; i&lt;ROWS.length; i++) { var row = ROWS[i]; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POJavascript complex array "element reduction" - building an HTML table based on array elements
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USgnarf
    1. USgnarf
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POJavascript complex array "element reduction" - building an HTML table based on array elements
      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
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou can grab the Array prototypal indexOf method here for use in browsers which don't implement it: https://developer.mozilla.org/Talk:en/Core_JavaScript_1.5_Reference/Global_Objects/Array
      singulars
      1. PO
      1. USmeder omuraliev
    2. COThanks for reminding me on that one (its a part of my global include script) - rewrote to use a different function anyway.
      singulars
      1. PO
      1. USgnarf
    3. COThanks SO much, gnarf - this is very helpful. I appreciate you taking the time. I think I was on the right track - I had begun to implement a pair of nested loops, but I got nervous when considering the implications of decrementing the counter within the loop if an array element was deleted. Looks like that's not a problem after all, though. I'm going to implement this in my project now, and will add another comment if I get stuck. Incidentally, it's probably JavaScript 101, but I haven't seen the syntax you used in setting up the for loops before - what exactly are those doing?
      singulars
      1. PO
      1. USBungle
 

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