StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POEXSLT date:format-date template without document() XSLT 1.0
primarykey
Id
2729243
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-04-28T12:09:50.353
FavoriteCount
0
LastActivityDate
2010-04-29T19:33:48.390
LastEditDate
2010-04-29T08:49:04.953
LastEditorUserId
270204
OwnerUserId
270204
ParentId
0
PostTypeId
1
Score
1
ViewCount
2828
LastEditorDisplayName
text
Body
I'm using <a href="http://www.exslt.org/date/functions/format-date/index.html" rel="nofollow noreferrer">date:format-date template EXSLT file</a> I'm using XSLT 1.0 and MSXML3.0 as the processor. My date:format-date template EXSLT file's declaration is: <pre><code><xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:date="http://exslt.org/dates-and-times" xmlns:str="http://exslt.org/strings" extension-element-prefixes="msxsl date str"> ... </xsl:stylesheet> </code></pre> I cannot use document() function due to the 3rd party restrictions. So I have changed the months and days (similarly) from XML snippet: <pre><code><date:months> <date:month length="31" abbr="Jan">January</date:month> <date:month length="28" abbr="Feb">February</date:month> <date:month length="31" abbr="Mar">March</date:month> <date:month length="30" abbr="Apr">April</date:month> <date:month length="31" abbr="May">May</date:month> <date:month length="30" abbr="Jun">June</date:month> <date:month length="31" abbr="Jul">July</date:month> <date:month length="31" abbr="Aug">August</date:month> <date:month length="30" abbr="Sep">September</date:month> <date:month length="31" abbr="Oct">October</date:month> <date:month length="30" abbr="Nov">November</date:month> <date:month length="31" abbr="Dec">December</date:month> </date:months> </code></pre> to the variable: <pre><code> <xsl:variable name="months"> <month length="31" abbr="Jan">January</month> <month length="28" abbr="Feb">February</month> <month length="31" abbr="Mar">March</month> <month length="30" abbr="Apr">April</month> <month length="31" abbr="May">May</month> <month length="30" abbr="Jun">June</month> <month length="31" abbr="Jul">July</month> <month length="31" abbr="Aug">August</month> <month length="30" abbr="Sep">September</month> <month length="31" abbr="Oct">October</month> <month length="30" abbr="Nov">November</month> <month length="31" abbr="Dec">December</month> </xsl:variable> </code></pre> And correspondingly, I've changed the code that originally uses document() function from: [from month processing bit of EXSLT stylesheet] <pre><code><xsl:variable name="month-node" select="document('')/*/date:months/date:month[number($month)]" /> </code></pre> to use MSXML3.0 node-set function: <pre><code><xsl:variable name="month-node" select="msxsl:node-set($months)/month[number($month)]" /> </code></pre> So I assumed that this would work. According to the EXLT instructions "The format pattern string is interpreted as described for the JDK 1.1 <a href="http://java.sun.com/products/archive/j2se-eol.html" rel="nofollow noreferrer">SimpleDateFormat class.</a>" [I used current version]. I'm specifing the month in accordance to <a href="http://java.sun.com/j2se/1.3/docs/api/java/text/SimpleDateFormat.html" rel="nofollow noreferrer">SimpleDateFormat class</a> as 'dd MMMMM yyyy' so that the month will be the full month's name, for example January. But it doesn't work :( I've looked in EXSLT stylesheet and it has got the logic to do that. Also there is logic to display the name of the week for a day using 'E' pattern, which doesn't work for me. Maybe changing from using document() to variables broke it. Would really appreciate any help. Many thanks! EXAMPLES <pre><code><xsl:call-template name="date:format-date"> <xsl:with-param name="date-time" select="'2010-07-01'"/> <xsl:with-param name="pattern" select="'dd MMMMM yyyy'" /> </xsl:call-template> </code></pre> As I understand from <a href="http://java.sun.com/j2se/1.3/docs/api/java/text/SimpleDateFormat.html" rel="nofollow noreferrer">SimpleDateFormat class</a> docs this should result in 01 July 2010 and what I get is 01 07 2010 <pre><code><xsl:call-template name="date:format-date"> <xsl:with-param name="date-time" select="'2010-07-01'"/> <xsl:with-param name="pattern" select="'EEE, dd MMMMM yyyy'" /> </xsl:call-template> </code></pre> This should result in Mon, 01 July 2010 and what I get is , 01 07 2010
Tags
<xslt><date><document><msxml><exslt>
Title
EXSLT date:format-date template without document() XSLT 1.0
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USDashaLuna
UserOwnerUserId
1. USDashaLuna
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. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POEXSLT date:format-date template without document() XSLT 1.0
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
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.