Category Summary to XML Package

[apastue@kingpar.com]

Does anyone know how to add the category summary to the category xml package

[MadStamper]

In your selected entity xmlpackage, add a new query like this:

<query name="CategorySummary" rowElementName="Category">
        <sql>
            <![CDATA[select Summary from Category where categoryID = @CatID]]>
        </sql>
        <queryparam paramname="@CatID" paramtype="runtime" requestparamname="CatID" sqlDataType="int" defvalue="0"  validationpattern="" />
    </query> 

Then down with all the other xml:param definitions add this:

<xsl:param name="catSummary" select="/root/CategorySummary/Category/Summary" /> 

Then where ever you want to display it use this:

<xsl:value-of select="$catSummary" disable-output-escaping="yes" />