sort with vbscript, selectSingleNode query sort xml - XML SOAP

Marc wrote:


> I'm using the following xslt to extract the first node from a set. I am
> using a sort to get the correct one.
>
> <xsl:for-each select="//*[@urlName='11']/node">
> <xsl:sort select="@sortOrder" data-type="number" order="ascending"/>
>
>
> I almost get the same result with the following vbscript line but have been
> unable to get the sort bit in there.
>
> Set Node = xmlDoc.selectSingleNode("//*[@urlName='11']/node")

Well xsl:sort is part of the XSLT language to make transformation, if
you use selectSingleNode on an MSXML document or node then you are
restricted to XPath and XPath has no features to sort.
The XPath functions you can use with MSXML are documented here
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/b5c850f1-077d-4200-81eb-f723436d65ae.asp>

If you need to sort/restructure the original document then with MSXML I
don't think you can avoid using XSLT, XPath alone does not do that.


--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

"Martin Honnen" <mahotrash@yahoo.de> wrote in message
news:%230DIs4Z1GHA.4632@TK2MSFTNGP03.phx.gbl...
>
>
> Marc wrote:
>
>
>> I'm using the following xslt to extract the first node from a set. I am
>> using a sort to get the correct one.
>>
>> <xsl:for-each select="//*[@urlName='11']/node">
>> <xsl:sort select="@sortOrder" data-type="number" order="ascending"/>
>>
>>
>> I almost get the same result with the following vbscript line but have
>> been unable to get the sort bit in there.
>>
>> Set Node = xmlDoc.selectSingleNode("//*[@urlName='11']/node")
>
> Well xsl:sort is part of the XSLT language to make transformation, if you
> use selectSingleNode on an MSXML document or node then you are restricted
> to XPath and XPath has no features to sort.
> The XPath functions you can use with MSXML are documented here
> <http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/b5c850f1-077d-4200-81eb-f723436d65ae.asp>
>
> If you need to sort/restructure the original document then with MSXML I
> don't think you can avoid using XSLT, XPath alone does not do that.
>
>
> --
>
> Martin Honnen --- MVP XML
> http://JavaScript.FAQTs.com/

Hi Martin,

Well... I was afraid the answer would be like that, thanks for the link and
your quick reply, I guess I need to use the xslt then.

Kind regards,

Marc

You could always try doing your select in code, stuffing the results into an array, sort the array, and then process each item in the array after they've been sorted.

--
Greg Collins [Microsoft MVP]
Visit Brain Trove ( http://www.BrainTrove.com )

"Greg Collins [Microsoft MVP]" <gcollins_AT_msn_DOT_com> wrote in message
news:ugN%23G5d1GHA.4924@TK2MSFTNGP05.phx.gbl...
You could always try doing your select in code, stuffing the results into an
array, sort the array, and then process each item in the array after they've
been sorted.

--
Greg Collins [Microsoft MVP]
Visit Brain Trove ( http://www.BrainTrove.com )

Oh... now there's an idea...