Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Kristian Sørensen 22 posts 42 karma points
    Dec 10, 2010 @ 13:46
    Kristian Sørensen
    0

    Order data - get by cdata

    Hi guys, 

    I trying to find out to sort some data, i have this. But like to sort it by "firmaUrl", is it possible?

    <xsl:variable name="sqlexp">

    <![CDATA[

    SELECT CAST(x.xml AS XML).query('/node/data[@alias="firmaLogo"]') AS kundeLogo, CAST(x.xml AS XML).query('/node/data[@alias="firmaStatement"]') AS kundeStatement, CAST(x.xml AS XML).query('/node/data[@alias="firmaUrl"]') AS kundeUrl

    FROM cmsContentXml AS x 

    INNER JOIN cmsMember AS m ON x.nodeId = m.nodeId

    WHERE CAST(x.xml AS XML).value('(/node/data[@alias="erAktiv"])[1]', 'int') = 1

    ]]>

    </xsl:variable>

    Thanks

Please Sign in or register to post replies

Write your reply to:

Draft