StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
2963707
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-06-03T06:21:06.053
FavoriteCount
0
LastActivityDate
2010-06-05T20:50:11.503
LastEditDate
2010-06-05T20:50:11.503
LastEditorUserId
329289
OwnerUserId
329289
ParentId
2963633
PostTypeId
2
Score
10
ViewCount
0
LastEditorDisplayName
text
Body
Well, if I use this stylesheet: <pre><code><?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="text"/> <xsl:template match="node/text()"> <xsl:copy/> </xsl:template> </xsl:stylesheet> </code></pre> on this XML file: <pre><code><?xml version="1.0" encoding="utf-8"?> <node id=1 text="Book Information" ><![CDATA[This is sample text]]></node> </code></pre> I get a parse error, because <code>id=1</code> is invalid XML. Putting quotes around the attribute value (<code>id="1"</code>) and rerunning the stylesheet, I get as output: <blockquote> This is sample text </blockquote> So there's a start. Basically, just treat the CDATA as a text node and you're on your way. You said: <blockquote> I found something like: <code><xsl:output cdata-section-elements="text"/></code> and then to fetch CDATA: <code><xsl:value-of select="node" /></code> </blockquote> This approach works just fine if you're using <code>value-of</code> as well. Here would be an example along the lines of your comment, using <code>value-of</code> instead. Note, though, that <code>cdata-section-elements</code> only works on the output side, indicating which output XML elements you want to print as CDATA sections instead of plain old character data. It doesn't have anything to do with fetching the data. <pre><code><?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output cdata-section-elements="foo"/> <xsl:template match="/"> <foo> <xsl:value-of select="node"/> </foo> </xsl:template> </xsl:stylesheet> </code></pre> prints out <pre><code><?xml version="1.0"?> <foo><![CDATA[This is sample text]]></foo> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to get CDATA from xml node using xsl ?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USOwen S.
UserOwnerUserId
1. USOwen S.
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
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COHi Owen, Well, thanks for your reply. Actually, I want CDATA under if condition. There are certain conditions depending upon them, I need assign this CDATA value to a Label control.
 singulars
 PostPostId
 PO
 UserUserId
 USVijay Balkawade
2. COHow about posting a snippet of what you're trying to do and where you want your value to go?
 singulars
 PostPostId
 PO
 UserUserId
 USOwen S.

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.