Databases
StackOverflow2013
Postsdbo
POCan't retrieve info from xml document with xsl
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCan't retrieve info from xml document with xsl
    text
    copied!<p>I'm starting to learn xml and xsl, but for some reason I can't make the xpath work for me in xsl. Is my xml document structured in a wrong way or why isn't the price of game 14 displayed in the table? </p> <p>My xsl attempt is pretty simple:</p> <pre><code>&lt;?xml version="1.0" encoding="ISO-8859-1"?&gt; &lt;!-- Edited by XMLSpy® --&gt; &lt;xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"&gt; &lt;xsl:template match="/"&gt; &lt;html&gt; &lt;body&gt; &lt;h2&gt;My Games&lt;/h2&gt; &lt;table border="1"&gt; &lt;tr bgcolor="#9acd32"&gt; &lt;th&gt;Game Name&lt;/th&gt; &lt;th&gt;Price&lt;/th&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;xsl:value-of select= "Xboxspellen/Spellen/Spel[14]/Spelnaam"/&gt;&lt;/td&gt; &lt;td&gt;&lt;xsl:value-of select= "Xboxspellen/Spellen/Spel[14]/Prijs"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/body&gt; &lt;/html&gt; &lt;/xsl:template&gt; &lt;/xsl:stylesheet&gt; </code></pre> <p>Shorter version of xml code:</p> <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;?xml-stylesheet type="text/xsl" href="Xboxspellen.xsl"?&gt; &lt;Xboxspellen xmlns="http://www.w3schools.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.w3schools.com Xboxspellen.xsd"&gt; &lt;Genres&gt; ... &lt;Genre id="Adv"&gt; &lt;Genrenaam&gt;Adventure&lt;/Genrenaam&gt; &lt;Spel idref="12"/&gt; &lt;Spel idref="13"/&gt; &lt;Spel idref="14"/&gt; &lt;/Genre&gt; &lt;/Genres&gt; &lt;Spellen&gt; ... ... &lt;Spel id="14"&gt; &lt;Spelnaam&gt;Omerta: city of gangsters&lt;/Spelnaam&gt; &lt;Uitgever&gt;Kalypso&lt;/Uitgever&gt; &lt;Prijs&gt;49.98&lt;/Prijs&gt; &lt;Leeftijd&gt;16&lt;/Leeftijd&gt; &lt;Aankoop&gt; &lt;Dag&gt;28&lt;/Dag&gt; &lt;Maand&gt;04&lt;/Maand&gt; &lt;Jaar&gt;2011&lt;/Jaar&gt; &lt;/Aankoop&gt; &lt;Afbeelding&gt;spel14.jpg&lt;/Afbeelding&gt; &lt;/Spel&gt; &lt;/Spellen&gt; &lt;/Xboxspellen&gt; </code></pre> <p>I've been trying things for hours but don't seem to find the answer, if anyone could help me, I'd be very thankful :D</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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