Passing parameters from ASP (VBScript) to XSLT

rj_mayer · March 19th, 2004, 05:53 AM

I need to pass a parameter to an XSL document from ASP (VBScript). I have come up with the following code, but the parameters are not displayed when passed to the XSL sheet. Can anyone help?

function showxmldata(strXMLFile, strXSLFile, strParam)

     dim blnXMLOK
     dim blnXSLOK
     dim strFilesErr

     set xmlDoc = Server.CreateObject("MSXML2.FreeThreadedDOMDocumen t")
     set xslDoc = Server.CreateObject("MSXML2.FreeThreadedDOMDocumen t")
     'xmlDoc.preserveWhiteSpace = true
     blnXMLOK = xmlDoc.load(strXMLFile)
     blnXSLOK = xslDoc.load(strXSLFile)

     if blnXMLOK and blnXSLOK then
          'check for parameters
          response.write "test - strParam = (" & strParam & ")" '***there is a value here
          if strParam <> "none" then
               set xslt = Server.CreateObject("MSXML2.XSLTemplate")
               set xslt.stylesheet = xslDoc
               Set xslProc = xslt.createProcessor()
               xslProc.input = xmlDoc
               xslProc.addParameter "Chapel", cstr(strParam)
               xslProc.transform
               sOutput = xslProc.output
               response.write sOutput
               set xslProc = nothing
               set xslt = nothing
          else
               Response.Write(xmlDoc.transformNode(xslDoc))
          end if
     else
          if not blnXMLOK then
                      strFilesErr = strFilesErr & "strXMLFile: " & strXMLFile
          end if
          if not blnXSLOK then
               strFilesErr = "<br>" & strFilesErr & "strXSLFile: " & strXSLFile
          end if
          DisplayError(strFilesErr)
     end if

     set xmlDoc = nothing
     set xslDoc = nothing
end function

pgtips · March 19th, 2004, 06:17 AM

Your method of passing parameters is fine. Maybe there is some problem in your XSLT?

BTW this snippet:
  xslProc.transform
  sOutput = xslProc.output
  response.write sOutput

can be replaced by this:
  xslProc.output = Response
  xslProc.transform

It's more efficient to stream the transform result directly to the Response object - this also has the advantage of preserving encoding.

Anyway, that's nothing to do with your problem - let's see your XSLT and if poss a snippet of your XML.

rgds
Phil

rj_mayer · March 19th, 2004, 06:23 AM

Thanks for this. It's a relief to know that there is nothing fundamentally wrong with the ASP!

My XML file can be found at http://www.techybits.net/ccsl/data/service.xml

My XSLT is as follows ...

<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<xsl:param name="Chapel"/>

<html>
<body>
<h1>Service in Detail for SID:172 --- <xsl:value-of select="$Chapel"/></h1>

    <xsl:for-each select="CHAPELDATA/SERVICE">
    <xsl:sort select="field[@id='Date']"/>
<xsl:value-of select="$Chapel"/>
    <xsl:if test="field[@id='SERVICEID']='SID:172'">

        <table border="1" cellpadding="2">

            <xsl:for-each select="field">
                <tr><td><xsl:value-of select="@id"/></td>
                <td><xsl:value-of select="field_value"/></td></tr>
            </xsl:for-each>
        </table>

    </xsl:if>
    </xsl:for-each>

</body>
</html>
</xsl:template>
</xsl:stylesheet>

pgtips · March 19th, 2004, 06:37 AM

Move the <xsl:param name="Chapel"/> outside of the <xsl:template match="/">...</xsl:template> block. You need it to be a top-level parameter if you want to externally supply a value.

rgds
Phil

rj_mayer · March 19th, 2004, 06:45 AM

That's great. It works. Thanks so much Phil.

thecloud2002 · January 25th, 2005, 04:20 PM

Thank you. Ive been looking for this.:)