StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5095542
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
6
CommunityOwnedDate
CreationDate
2011-02-23T18:45:57.517
FavoriteCount
0
LastActivityDate
2011-02-23T22:44:46.013
LastEditDate
2011-02-23T22:44:46.013
LastEditorUserId
529237
OwnerUserId
529237
ParentId
5095483
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
It should read <code><xsl:for-each select="attachment">...</code>. There is no <code>$</code> sign because <code>attachment</code> is the name of an XML element, not a variable. <hr> EDIT after you've given the full XSLT and XML. There are several problems with your XML: <ul> <li>All tags should be closed.</li> <li>You may not use the <code>xmlns</code> for anything else that it's meant for — namespaces.</li> <li>You must have double quotes around the attribute values</li> </ul> So a correct version of the XML file would be (for instance): <pre><code><root> <attachment ptr="file1" /> <attachment ptr="file2" /> </root> </code></pre> The XSLT file has some issues too: <ul> <li>The <code>xsl</code> namespace should be bound to the exact URI <code>http://www.w3.org/1999/XSL/Transform</code>.</li> <li>You must have at least a template so that the XSLT transform processes your input XML document.</li> </ul> A correct version would be, for instance: <pre><code><?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/root"> <xsl:for-each select="attachment"> <a target="_blank" href="{@ptr}"><xsl:value-of select="@ptr" /></a> </xsl:for-each> </xsl:template> </xsl:stylesheet> </code></pre> I'm not sure it is exactly what you want, but for the above document it produces the following fragment: <pre><code><a target="_blank" href="file1">file1</a> <a target="_blank" href="file2">file2</a> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POhow to iterate through XML param in XSLT
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USChrisJ
UserOwnerUserId
1. USChrisJ
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. CO@ChrisJ: `attachment` XPath expression would select `attachment` children of context node (parameter reference not used)
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
2. CO@Alejandro: I've updated the answer after you've added the full XSLT.
 singulars
 PostPostId
 PO
 UserUserId
 USChrisJ
3. CO@ChrisJ: Now is better. You wrote: *"You must have at least a template so that the XSLT transform processes your input XML document"*. That's not true. Do test it. Besides that you didn't address the question title.
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.

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.