Re: [xsl] Loading XML with XSL for sorting in ASP

[Bjorn Van Blanckenberg <bjornvb@xxxxxx>]

The output xml I hope to get

<?xml version="1.0" encoding="ISO-8859-1"?>
<catalog>
	<settings>
		<user>
			<owner>User1</owner>
			<other>
				<name>User2</name>
				<total>3</total>
				<nodig>-5</nodig>
			</other>
			<other>
				<name>User3</name>
				<total>14</total>
				<nodig>6</nodig>
			</other>
		</user>
		<user>
			<owner>User2</owner>
			<other>
				<name>User1</name>
				<total>8</total>
				<nodig>5</nodig>
			</other>
			<other>
				<name>User3</name>
				<total>7</total>
				<nodig>-2</nodig>
			</other>
		</user>
		<user>
			<owner>User3</owner>
			<other>
				<name>User1</name>
				<total>33</total>
				<nodig>-6</nodig>
			</other>
			<other>
				<name>User2</name>
				<total>9</total>
				<nodig>2</nodig>
			</other>
		</user>
	</settings>
	<DVD>
		<title>A_title</title>
		<year>The Year</year>
		<owner>User3</owner>
		<counter>1</counter>
		<other>
			<name>A_user</name>
			<status>ok</status>
			<finalstatus>ok</finalstatus>
		</other>
		<other>
			<name>B_user</name>
			<status>see</status>
			<finalstatus>waiting</finalstatus>
		</other>
		<other>
			<name>C_user</name>
			<status>ok</status>
			<finalstatus>ok</finalstatus>
		</other>
	</DVD>
	<DVD>
		<title>B_title</title>
		<year>The Year</year>
		<owner>User3</owner>
		<counter>1</counter>
		<other>
			<name>A_user</name>
			<status>ok</status>
			<finalstatus>ok</finalstatus>
		</other>
		<other>
			<name>B_user</name>
			<status>see</status>
			<finalstatus>waiting</finalstatus>
		</other>
		<other>
			<name>C_user</name>
			<status>ok</status>
			<finalstatus>ok</finalstatus>
		</other>
	</DVD>
</catalog>

hope this helps


On 24-jan-06, at 12:59, cknell@xxxxxxxxxx wrote:

> Show us what output you hope to get, and you will most likely  
> receive some help. Guessing is not conducive to good results. The  
> ASP is irrelevant to your problem, the expected output is.
> --
> Charles Knell
> cknell@xxxxxxxxxx - email
>
>
>
> -----Original Message-----
> From:     Bjorn Van Blanckenberg <bjornvb@xxxxxx>
> Sent:     Tue, 24 Jan 2006 12:32:55 +0100
> To:       xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject:  [xsl] Loading XML with XSL for sorting in ASP
>
> My problem is that I want to sort  all the DVD nodes of my XML and
> use asp to convert it to html.
> the XSL just has to sort all the DVD and the settingsnode may not be
> altered.
>
> If it's possible I want to sort every othernode by name in evry  
> DVDnode.
>
> Can somebody help me with the XSL because now it seems that I dont
> get any output
>
> Below I've posted a piece of the ASP code and XML and full XSL
>
> Thanks Bjorn
>
>
>
> my ASP
>
> 'Load the XML file.
> 	set objXMLbron = Server.CreateObject("Microsoft.XMLDOM")
> 	objXMLbron.async = false
> 	objXMLbron.load(xmlFile)
> 	
> 	'Load the XSL file.
> 	set objXSL = Server.CreateObject("Microsoft.XMLDOM")
> 	objXSL.async = false
> 	objXSL.load(server.MapPath("sorttit3.xsl"))
>
> 	set objXML = Server.CreateObject("Microsoft.XMLDOM")
> 	'load transformed unsorted XMl and sort it
> 	objXML.loadXML(objXMLbron.transformNode(objXSL))
>
> 	set objXML = objXMLbron.transformNode(objXSL)
> 	
> 	Set objRoot = objXML.documentElement
>
> my XML
>
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <catalog>
> 	<settings>
> 		<user>
> 			<owner>User1</owner>
> 			<other>
> 				<name>User2</name>
> 				<total>3</total>
> 				<nodig>-5</nodig>
> 			</other>
> 			<other>
> 				<name>User3</name>
> 				<total>14</total>
> 				<nodig>6</nodig>
> 			</other>
> 		</user>
> 		<user>
> 			<owner>User2</owner>
> 			<other>
> 				<name>User1</name>
> 				<total>8</total>
> 				<nodig>5</nodig>
> 			</other>
> 			<other>
> 				<name>User3</name>
> 				<total>7</total>
> 				<nodig>-2</nodig>
> 			</other>
> 		</user>
> 		<user>
> 			<owner>User3</owner>
> 			<other>
> 				<name>User1</name>
> 				<total>33</total>
> 				<nodig>-6</nodig>
> 			</other>
> 			<other>
> 				<name>User2</name>
> 				<total>9</total>
> 				<nodig>2</nodig>
> 			</other>
> 		</user>
> 	</settings>
> 	<DVD>
> 		<title>The title</title>
> 		<year>The Year</year>
> 		<owner>User3</owner>
> 		<counter>1</counter>
> 		<other>
> 			<name>User3</name>
> 			<status>ok</status>
> 			<finalstatus>ok</finalstatus>
> 		</other>
> 		<other>
> 			<name>User2</name>
> 			<status>see</status>
> 			<finalstatus>waiting</finalstatus>
> 		</other>
> 		<other>
> 			<name>User1</name>
> 			<status>ok</status>
> 			<finalstatus>ok</finalstatus>
> 		</other>
> 	</DVD>
> </catalog>
>
> my XSL
>
> <?xml version="1.0" encoding="UTF-8"?>
> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/
> Transform">
> <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>
>
> <xsl:template match="/catalog">
>    <xsl:apply-templates>
>     <xsl:sort select="title" />
>    </xsl:apply-templates>
> </xsl:template>
>
> <xsl:template match="node()|@*">
>    <xsl:copy>
>     <xsl:apply-templates select="node()|@*">
>      <xsl:sort select="title" />
>     </xsl:apply-templates>
>    </xsl:copy>
> </xsl:template>
>
> </xsl:stylesheet>