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

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies