Thread: Display Distributor Name

How can I display the corresponding distributor name on the notification.distributor.xml.config XML package?

Thx!

I have not tested it, but the following steps should allow you to display the distributor name in your notification.distributor.xml.config XML package.

1) Insert this query into your XML Package (which is responsible for retrieving the distributor name from the database, based on the distributor id being passed through as a runtime parameter):

Code:

 <query name="Distributor" rowElementName="Data">
    <sql>
      <![CDATA[
            SELECT D.Name FROM Distributor D WITH(NOLOCK) WHERE d.DistributorID = @distributorid
            ]]>
    </sql>    
    <queryparam paramname="@distributorid" paramtype="runtime" requestparamname="DistributorID" defvalue="0" sqlDataType="int" validationpattern="^\d{1,9}$"/>
  </query>

2) Place the following code where you would like to have the distributor name appear:

Code:

<xsl:value-of select="aspdnsf:GetMLValue(/root/Distributor/Data/Name)" />

If you plan on placing the name multiple times throughout the xml package, you could consider using a param:

Code:

<xsl:param name="DistributorName" select="aspdnsf:GetMLValue(/root/Distributor/Data/Name)" />

Code:

<xsl:value-of select="$DistributorName" />

Let me know if that works out for you.

Robert

That worked like a charm, thanks a lot!

Great! Your welcome!