Hi,
When Webopius created an updated GoogleBase feed, the query was modified along these lines...
Change the select to:
Code:
select p.productid, p.name, m.name brandname, ....and keep all the other select items...
Add this to the from clause:
Code:
left join dbo.productmanufacturer pm with (NOLOCK) on p.productid = pm.productid
join dbo.manufacturer m with (NOLOCK) on pm.manufacturerid = m.manufacturerid
Then in the Product template, retrieve the brand name:
Code:
<xsl:param name="BrandName" select="aspdnsf:GetMLValue(brandname)"></xsl:param>
..and use it:
Code:
<g:brand>
<xsl:value-of select="$BrandName" />
</g:brand>
Hope this helps,
Adam. Webopius.com