Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Category Summary to XML Package

  1. #1
    apastue@kingpar.com is offline Junior Member
    Join Date
    Nov 2009
    Location
    Michigan
    Posts
    20

    Default Category Summary to XML Package

    Does anyone know how to add the category summary to the category xml package
    Thank you,

    Andrew Pastue
    http://www.kingparsuperstore.com

  2. #2
    MadStamper is offline Member
    Join Date
    Jan 2007
    Location
    Evansville, IN
    Posts
    57

    Default

    In your selected entity xmlpackage, add a new query like this:
    C#/VB.NET Code:
    <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:
    C#/VB.NET Code:
    <xsl:param name="catSummary" select="/root/CategorySummary/Category/Summary" /> 
    Then where ever you want to display it use this:
    C#/VB.NET Code:
    <xsl:value-of select="$catSummarydisable-output-escaping="yes" /> 
    -----------------------------------------------------
    MadStamper
    9.3 VB - http://www.SignsOverAmerica.com