数据源标签:
查询语句:
SELECT TOP 1 CM.*,UT.*,CH.*,PEU.UserName,PEU.TrueName,PEU.UserFace,SI.SpecialID
FROM
PE_CommonModel CM
INNER JOIN PE_U_Soft UT ON (CM.ItemID = UT.ID)
left join PE_SpecialInfos SI ON (CM.ItemID = SI.GeneralID)
left join PE_ContentCharge CH on (CM.GeneralID=CH.GeneralID)
INNER JOIN PE_Users PEU ON (CM.Inputer = PEU.UserName)
WHERE
CM.GeneralID = @itemId AND
CM.Status = 99
标签内容加上:
<special>
<xsl:if test="/NewDataSet/Table/SpecialID > 0">
<p><em>所属专辑:</em>
<a href='<xsl:value-of select="pe:GetSpecialPath(/NewDataSet/Table/SpecialID)"/>' target='_blank'>
<xsl:value-of select="pe:GetSpecialInfo(/NewDataSet/Table/SpecialID, 'SpecialName')"/>
</a>
</p>
</xsl:if>
</special>