Ciao, scusate sapete dirmi perchè se estratti in formato XML i nomi dei campi di una tabella mysql vengono scritti così:
Entità_Cod diventa in XML c3
`DurNettaFino8ore (sec)` diventa in XML c20
`DurSosp (sec)` diventa in XML c23
`DurNettaTotale (sec)` diventa in XML c28
`DurNettaOltre8ore (sec)` diventa in XML c26![]()
codice:<?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema"> <xsl:output omit-xml-declaration="yes"/> <xsl:template match="/"> <xsl:for-each select="/xml/s:Schema/s:ElementType/s:AttributeType"> <xsl:value-of select="@name"/> <xsl:choose> <xsl:when test="position()!=last()"> <xsl:text>	</xsl:text> </xsl:when> <xsl:otherwise> <xsl:text>
</xsl:text> </xsl:otherwise> </xsl:choose> </xsl:for-each> <xsl:for-each select="/xml/rs:data/z:row"> <xsl:variable name="row" select="."/> <xsl:for-each select="/xml/s:Schema/s:ElementType/s:AttributeType"> <xsl:variable name="columnName" select="@name"/> <xsl:value-of select="translate($row/@*[name()=$columnName],'.',',')" /> <xsl:if test="position()!=last()"> <xsl:text>	</xsl:text> </xsl:if> </xsl:for-each> <xsl:text>
</xsl:text> </xsl:for-each> </xsl:template> </xsl:stylesheet>

Rispondi quotando