Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If in your situation you always have exactly three 'pieces', separated by <code>br</code>s, you can use this XPath to get the middle 'piece':</p> <pre><code>//node()[preceding::br and following::br] </code></pre> <p>which uses the <code>preceding</code> and <code>following</code> axes to return all nodes between two <code>br</code>s, anywhere at all.</p> <p><em>edit</em> this is my test app (please excuse the <code>XmlDocument</code>, I am still working with .NET 2.0...)</p> <pre><code>using System; using System.Xml; namespace ConsoleApplication1 { class Program { static void Main(string[] args) { XmlDocument doc = new XmlDocument(); doc.LoadXml(@" &lt;x&gt; &lt;h3&gt;Section title&lt;/h3&gt; &lt;p&gt; &lt;b&gt;Component A&lt;/b&gt;&lt;br /&gt; Component B &lt;i&gt;includes&lt;/i&gt; &lt;strong&gt;multiple elements&lt;/strong&gt;&lt;br /&gt; Component C &lt;/p&gt; &lt;/x&gt; "); XmlNodeList nodes = doc.SelectNodes( "//node()[preceding::br and following::br]"); Dump(nodes); Console.ReadLine(); } private static void Dump(XmlNodeList nodes) { foreach (XmlNode node in nodes) { Console.WriteLine(string.Format("--&gt;{0}&lt;---", node.OuterXml)); } } } } </code></pre> <p>And this is the output:</p> <pre><code>--&gt; Component B &lt;--- --&gt;&lt;i&gt;includes&lt;/i&gt;&lt;--- --&gt;includes&lt;--- --&gt;&lt;strong&gt;multiple elements&lt;/strong&gt;&lt;--- --&gt;multiple elements&lt;--- </code></pre> <p>As you can see, you get an <code>XmlNodeList</code> with all the stuff between the <code>br</code>s.</p> <p>The way I think about it is: This XPath returns any node anywhere, so long as <em>for that node</em>, the preceding axis contains a <code>br</code>, <strong>and</strong> the following axis contains a <code>br</code>.</p>
    singulars
    1. This table or related slice is empty.
    1. POSelecting (siblings) between two tags using XPath (in .NET)
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAakashM
    1. USAakashM
    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. COA quick test suggests that this doesn't work (unless I've made some other stupid mistake). My understanding was that when a node-set expression appears within a filter clause, it acts as a 'true' value if it contains any items, whereas for this to work it would instead have to perform a set-membership test (ie, act as 'true' only if the node being filtered is within the set returned by the node-set expression). In this case, there are always some nodes before a br, and some nodes after, so it just selects everything. Please correct my understanding if I've got this wrong!
      singulars
      1. PO
      1. USJohn Bartholomew
    2. COAh, I see. I was thinking about it the wrong way round. Thanks for the clarification.
      singulars
      1. PO
      1. USJohn Bartholomew
 

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