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
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>
is working on a reply...