Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>For #1, you need to make your <code>drop</code> function just a little bit more intelligent. Inside of it, check to make sure that there are no <code>childNodes</code> before appending the Child.</p> <p>For #2, you need to make both <code>drag</code> and <code>drop</code> more intelligent. In <code>drag</code>, you need to look at the target and set some group information. In <code>drop</code>, you need to check that information to see if it matches appropriately.</p> <p>I can show you what #1 should look like:</p> <pre><code>function drop(ev) { ev.preventDefault(); if (ev.target.hasChildNodes()) { return; } // ...all the rest as you had it </code></pre> <p>For #2, it will be a bit more complex, depending on how you want to define the second set of icons. Generally, it should make your code look something like this:</p> <pre><code>function drag(ev) { ev.dataTransfer.setData("Text",ev.target.id); // I'm going to assume your group1 items will have "group1" in their id. Set it up however you want. if (ev.target.id.indexOf("group1") != -1) { ev.dataTransfer.setData("Group", 1); } else { ev.dataTransfer.setData("Group", 2); } // ...all the rest as you had it } function drop(ev) { ev.preventDefault(); if (ev.target.hasChildNodes()) { return; } if (ev.target.id.indexOf("group1") != -1 &amp;&amp; ev.dataTransfer.getData("Group") == 2 || ev.target.id.indexOf("group2") != -1 &amp;&amp; ev.dataTransfer.getData("Group") == 1) { return; } // ...all the rest as you had it </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POhtml5 drag and drop prevent drop unless div empty
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USScott Mermelstein
    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. This table or related slice is empty.
    1. COPart 2 worked flawlessly - thank you so much for help. I'm still having problems with part 1 though - while it no longer overrides the icon when dropped, it still allows the drop to occur, resulting in a lost icon and requiring a page refresh (I can see how that might be my fault for phrasing the question incorrectly). Edit: Using the drop code as above also pulls the next icon in the group on drop, which is not necessary the the one I was dragging if I go out of order.
      singulars
      1. PO
      1. UScloudy
    2. CO@cloudy Without more information, I can't give you better specifics. One thing you should do is look more into [Drag and Drop](https://developer.mozilla.org/en-US/docs/DragDrop/Drag_and_Drop), as you'll find lots of ways to work around your issue. In the link, you can see that you can set the Drag Effect. As best as I can figure, you've got it set to "move", and you may not want that. You can implement the `dragOver` event and tell the system that you won't allow a drop (good for your #1). For your #2 issue, all I can tell is that somehow your filters aren't set up right.
      singulars
      1. PO
      1. USScott Mermelstein
 

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