Hi,
i create a xml template to query a sql database. I like to
view results in html format and i create a xsl file to do this.
I like to view datetime field in a better format that default
in my html table.. How can I change the output format of
datetime field?
See the FAQ <http://www.dpawson.co.uk/xsl/sect2/dates.html> - you need to use
the XPath String functions
<http://www.w3.org/TR/xpath.html#section-String-Functions> to parse the date
string and format it. There are extensions <http://exslt.org/date/index.html>
but they are not supported by all XSLT processors
More: I like to view "TRUE" or "FALSE" instead of 1 or 0 of
bit field. It's Possibile?
if you have e.g.
<foo>1</foo>
Then use
<xsl:template match="value">
<xsl:choose>
<xsl:when test=". = 1">TRUE</xsl:when>
<xsl:otherwise>FALSE</xsl:otherwise>
</xsl:choose>
<xsl:template>
or
<xsl:value-of select="boolean(number(.))"/>
if lowercase text is acceptable.
Cheers,
Jarno - De/Vision: Endlose Traume