RE: [xsl] Sorting by an attribute

Subject: RE: [xsl] Sorting by an attribute
From: Bagchi Ratul <bratul@xxxxxxxx>
Date: Tue, 9 Apr 2002 11:23:00 +0200
Yes,it is very much possible.

-----Original Message-----
From: Vrajitoru [mailto:vrajitoru@xxxxxxxx]
Sent: Tuesday, April 09, 2002 3:39 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: [xsl] Sorting by an attribute


I have a XML created by a ado.recordset. This XML looks like:

<?xml version='1.0' ?>
<?xml-stylesheet type='text/xsl' href='raport.xsl'?><data>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12358' Data='2000-10-19' Furnizor='32802' Comanda='X'
Valoare='757900.0'/>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12710' Data='2000-10-24' Furnizor='4560' Comanda='X'
Valoare='76191050.0'/>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12881' Data='2000-10-25' Furnizor='43049' Comanda='X'
Valoare='1277790.0'/>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12883' Data='2000-10-25' Furnizor='43049' Comanda='X'
Valoare='1243640.0'/>
<row Cod='230' Denumire='IESIRI PTR.PROD.DE BAZA' Document='BON CONSUM'
Numar='1005000' Data='2002-01-09' Furnizor='x' Comanda='540788/34'
Valoare='19238.52'/>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12359' Data='2000-10-19' Furnizor='10021' Comanda='X'
Valoare='11097150.0'/>
<row Cod='110' Denumire='INTRARE DE LA FURNIZORI' Document='NRCD'
Numar='1381' Data='2000-10-25' Furnizor='32262' Comanda='X'
Valoare='3417750.0'/>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12360' Data='2000-10-19' Furnizor='10021' Comanda='X'
Valoare='5380330.0'/>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12888' Data='2000-10-25' Furnizor='3002' Comanda='X'
Valoare='2871600.0'/>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12889' Data='2000-10-25' Furnizor='3002' Comanda='X'
Valoare='2789400.0'/>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12891' Data='2000-10-25' Furnizor='28075' Comanda='X'
Valoare='7324500.0'/>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12361' Data='2000-10-19' Furnizor='10021' Comanda='X'
Valoare='17040725.0'/>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12892' Data='2000-10-25' Furnizor='14118' Comanda='X'
Valoare='1748000.0'/>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12362' Data='2000-10-19' Furnizor='10021' Comanda='X'
Valoare='25998055.0'/>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12363' Data='2000-10-19' Furnizor='12168' Comanda='X'
Valoare='2720200.0'/>
<row Cod='110' Denumire='INTRARE DE LA FURNIZORI' Document='NRCD'
Numar='1384' Data='2000-10-25' Furnizor='32295' Comanda='X'
Valoare='2730000.0'/>
<row Cod='212' Denumire='VINZARI CATRE ALTE UNITATI' Document='FACTURA'
Numar='12894' Data='2000-10-25' Furnizor='3113' Comanda='X'
Valoare='3240000.0'/>
</data>

Is there a possibility to make a XSL that sorts this XML on a specific
attribute? ('Cod' for example)

Thanks

Vrajitoru

PS: This is a simple XSL that i made to test the sort function but it
doesn't work:

<?xml version='1.0'?><xsl:stylesheet version='1.0'
xmlns:xsl='http://www.w3.org/1999/XSL/Transform'><xsl:output method='html'/>
<xsl:template match='/'>
<html>
<head>
<title>Titlu</title>
</head>
<body>
<h1 align='center'>Titlul raportului</h1>
<table border='1' cellpadding='0' cellspacing='0' width='100%'>
<tr>
<th>Cod</th><th>Denumire</th><th>Document</th><th>Numar</th><th>Data</th><th
>Furnizor</th><th>Comanda</th><th>Valoare</th>
</tr>
<xsl:apply-templates>
<xsl:sort select="row[@Cod]" order="ascending" data-type="number" />
</xsl:apply-templates>
</table>
</body>
</html>
</xsl:template>

<xsl:template match='row'>
<tr>
<td valign='Top' align='Left'><xsl:value-of select='@Cod'/></td>
<td valign='Top' align='Left'><xsl:value-of select='@Denumire'/></td>
<td valign='Top' align='Left'><xsl:value-of select='@Document'/></td>
<td valign='Top' align='Left'><xsl:value-of select='@Numar'/></td>
<td valign='Top' align='Left'><xsl:value-of select='@Data'/></td>
<td valign='Top' align='Left'><xsl:value-of select='@Furnizor'/></td>
<td valign='Top' align='Left'><xsl:value-of select='@Comanda'/></td>
<td valign='Top' align='Right'><xsl:value-of select='@Valoare'/></td>
</tr>
</xsl:template>
</xsl:stylesheet>



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread