I need help with passing a generated node set from a style sheet into my customer msxsl extension. I have the following node set that I am creating:
<xsl:variable name="sql">
<SQL>
<StoredProc>spG etReconID</StoredProc>
<Parms>
<parm>
<name>@tran</name>
<value>956</value>
</parm>
<parm>
<name>@refnbr </name>
<value><xsl:val ue-of select="$shipnb r"/></value>
</parm>
<parm>
<name>@keyfld </name>
<value><xsl:val ue-of select="$ponbr"/></value>
</parm>
</Parms>
</SQL>
</xsl:variable>
<xsl:value-of select="user:Ge tDBValue('myDB' , msxsl:node-set($sql))"/>
The return value is just a string as we only want to return a single value. The above code is inside a template and that is why we execute the user function with only a value-of statement. We are trying to create a generic type function that is why we are trying to use the node-set to allow future flexibility. When we receive the node-set in the extended function we only see the XML that was passed to the style sheet and not the above node-set. Does anyonen have a sample they can share on how to get this working?
Thanks,
Matt
<xsl:variable name="sql">
<SQL>
<StoredProc>spG etReconID</StoredProc>
<Parms>
<parm>
<name>@tran</name>
<value>956</value>
</parm>
<parm>
<name>@refnbr </name>
<value><xsl:val ue-of select="$shipnb r"/></value>
</parm>
<parm>
<name>@keyfld </name>
<value><xsl:val ue-of select="$ponbr"/></value>
</parm>
</Parms>
</SQL>
</xsl:variable>
<xsl:value-of select="user:Ge tDBValue('myDB' , msxsl:node-set($sql))"/>
The return value is just a string as we only want to return a single value. The above code is inside a template and that is why we execute the user function with only a value-of statement. We are trying to create a generic type function that is why we are trying to use the node-set to allow future flexibility. When we receive the node-set in the extended function we only see the XML that was passed to the style sheet and not the above node-set. Does anyonen have a sample they can share on how to get this working?
Thanks,
Matt
Comment