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: Manufacturer name on category/subcat pages.

  1. 09-15-2011, 06:23 AM #1
    bdamore is offline Member
    Join Date
    Jun 2011
    Posts
    52

    Default Manufacturer name on category/subcat pages.

    Hello. We would like the manufacturer's name to show up on our category/sub category pages. for example:
    http://aspdotnetstorefront.nueratrai...-hardware.aspx
    Where it says "Brand -" it should say the manu name...

    I have tried the following as per this article:
    http://forums.aspdotnetstorefront.co...p?t-7655.html&

    Code added:
    AT TOP
    <query name="ProductMans" rowElementName="Man">
    <sql>
    <![CDATA[
    SELECT ManufacturerID ManID
    FROM ProductManufacturer pm
    WHERE pm.ProductID = @ProductID
    ]]>
    </sql>
    <queryparam paramname="@ProductID" paramtype="request" requestparamname="ProductID" sqlDataType="int" defvalue="0" validationpattern="^\d{1,10}$" />
    </query>

    IN TEMPLATE
    <xsl:value-of select="root/EntityHelpers/Manufacturer/Entity[EntityID=/root/ProductMans/Man/ManID]/Name" disable-output-escaping="yes"/>

    It's not bombing, but nothing is showing up...
    What am I missing?

    Thanks
  2. 09-15-2011, 07:11 AM #2
    bdamore is offline Member
    Join Date
    Jun 2011
    Posts
    52

    Default Solved

    I just needed the following in the template since it's already getting the manID in the base 'Products' query

    <xsl:value-of select="/root/EntityHelpers/Manufacturer/Entity[EntityID=/root/Products/Product/ManufacturerID]/Name" disable-output-escaping="yes"/>