Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>This is a solution to the problem as described in the comments (though not the actual question). I think it would be much faster the use <code>elementFromPoint</code> to test the area where you want to put your fixed-position element, and only worry about elements in that area. An example is here:</p> <p><a href="http://jsfiddle.net/pQgwE/4/" rel="nofollow">http://jsfiddle.net/pQgwE/4/</a></p> <p>Basically, just set some minimum possible size of an element you're looking for, and scan the entire area that your new fixed position element wants to occupy. Build a list of unique elements found there, and only worry about checking the style of those elements.</p> <p>Note that this technique assumes that the element you're looking for has the highest z-index (which seems a reasonable assumption for fixed position). If this is not good enough, then this could be adjusted to hide (or assign a minimum z-index) to each element after it's been discovered and test the point again, until nothing more is found (to be sure), and then restore them afterwards. This ought to happen so fast as to be imperceptible.</p> <p>HTML:</p> <pre><code>&lt;div style="position:fixed; left: 10px; top: 10px; background-color: #000000; color: #FF0000;"&gt;I Am Fixed&lt;/div&gt; &lt;div id="floater"&gt;OccupyJSFiddle!&lt;br&gt;for two lines&lt;/div&gt; </code></pre> <p>JS:</p> <pre><code>var w = $(window).width(), h=$(window).height(), minWidth=10, minHeight=10, x,y; var newFloat = $('#floater'), maxHeight = newFloat.height(), el, uniqueEls=[], i; for (x=0;x&lt;w;x+=minWidth) { for (y=0;y&lt;h&amp;&amp; y&lt;maxHeight;y+=minHeight) { el = document.elementFromPoint(x,y); if (el &amp;&amp; $.inArray(el,uniqueEls)&lt;0) { uniqueEls.push(el); } } } // just for the fiddle so you can see the position of the elements // before anything's done // alert("click OK to move the floater into position."); for (i=0;i&lt;uniqueEls.length;i++) { el = $(uniqueEls[i]); if (el.css("position")==="fixed") { el.css("top",maxHeight+1); } } newFloat.css({'position': 'fixed', 'top': 0, 'left': 0}); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POmost efficient way to iterate over all DOM elements?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJamie Treworgy
    1. USJamie Treworgy
    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 for this attempt. However I don't believe it will work in my case. I've updated your example to be more similar to what i'm seeing in production. http://jsfiddle.net/pQgwE/5/ Two fixed positioned elements at top:0px overlapping. also in my case there are multiple fixed elements in the external design. Some of them positioned relative to others so doint an elementFromPoint method could get out of hand quickly.
      singulars
      1. PO
      1. USkevzettler
    2. COUnless you have two overlapping elements that actually take up exactly the same real estate, it will still work, see: http://jsfiddle.net/pQgwE/14/ -- the change you made turned the element that was supposed to be yours into something else. But if for some reason you expect your clients to have multiple fixed position elements in exactly the same real estate (which makes no sense, since they would interfere with each other) there's no reason you can't do what I already suggested above: after you detect each one, hide it or lower its z-index, and check again to see what was behind it.
      singulars
      1. PO
      1. USJamie Treworgy
    3. CObtw i'm not sure what you mean by "elementFromPoint method could get out of hand quickly". It doesn't matter whether elements are positioned relatively, or anything else. That's what is so great about that method. It tells you what's at a specific point regardless of how it got there. What you do once you detect an element you need to move is exactly the same using this method, as it would be if you iterated through the entire DOM to find them. It's just a lot less work to find the stuff you're interested in this way.
      singulars
      1. PO
      1. USJamie Treworgy
 

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