StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
10714174
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-05-23T05:50:44.493
FavoriteCount
0
LastActivityDate
2012-05-23T05:50:44.493
LastEditDate
LastEditorUserId
0
OwnerUserId
317052
ParentId
10705845
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Are you trying to process the transformation by opening the XML in a web browser? If you are, what you're seeing is the browsers attempt to render the output after the transform is complete. Since the browser has no idea how to display vxml, you only see text nodes. What would help is for you to use an XSLT processor. I'd recommend <a href="http://saxon.sourceforge.net/" rel="nofollow">Saxon</a>. Saxon-HE would be perfect to get you started. The documentation should easily get you running transforms from the command line. I added another XSLT 1.0 example you can use. The most important piece is the identity template. This will copy all nodes (text/elements/comments/processing instructions) and attributes as-is without modification (as long as they are not overridden by another template). Just add new templates if you need to override the identity template. Also, I stole Franci Avila's <code>id</code> creation but used an <a href="http://www.w3.org/TR/xslt#attribute-value-templates" rel="nofollow">AVT</a> instead of <code>xsl:attribute</code>. I did this just to show an AVT. AVTs are also very handy to learn. XML Input (I removed the <code>xml-stylesheet</code> PI from the input. If I didn't remove it, I'd have to override the identity template to strip it.) <pre><code><myProjtag> <prompt>I am here</prompt> <prompt>I am not here</prompt> </myProjtag> </code></pre> XSLT 1.0 <pre><code><xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output indent="yes"/> <xsl:strip-space elements="*"/>  <xsl:template match="node()|@*"> <xsl:copy> <xsl:apply-templates select="node()|@*"/> </xsl:copy> </xsl:template> <xsl:template match="/"> <vxml version="2.0" lang="en"> <form id="{substring(local-name(/*), 0, string-length(local-name(/*))-2)}"> <xsl:apply-templates select="*/*"/> </form> </vxml> </xsl:template> </xsl:stylesheet> </code></pre> XML Output <pre><code><vxml version="2.0" lang="en"> <form id="myProj"> <prompt>I am here</prompt> <prompt>I am not here</prompt> </form> </vxml> </code></pre> If you have any questions on the XSLT, running Saxon from the command line, etc., just let me know.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POConversion of XML to VXML using XSLT
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USDaniel Haley
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. This table or related slice is empty.
CommentsPostId
1. 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.