XML DMO Problem

  • Hello

    Following is configuration of the server and client machine.

    Sever : Windows 2000 + IIS 5.0

    Client : Window XP + SP2.

    On my website home page i have may combo-boxes which are filled with master values from the SQL SERVER 2000 Tables. Everytime the home page is being loaded it takes lots of time to load the page due to large number of mater values to be filled in all the combo-boxes.

    So to overcome this problem i created the XMLs file containing values for the Combo-boxes to be filled up on the home page. Now to efficiently load the XML file values i made use of XSLT with XML DOM. It worked properly and was loading the home page efficiently on Windows 98 machine where on referring the xml file it brings the file from the server and dump into the client machine and on subsequent access to home page the combo-boxes were loaded from the file present on client machine as the file on ther server was not being changed. Whenever the file was being changed on server it dumps the new file to client machine on access the home page if it finds that the file on server is being change by comparing the timestamp of client machine file and timestamp of server file.

    Now PROBLEM is on WIN XP with SP2 everytime it brings the file from ther server and dumps into client machine on accessing the home page. Which was not the case with Windows 98 machine.

    Please help how to overcome this problem with Window XP with SP2 so that i can load the home acessing the xml file present in client machine instead of bringing everytime from the server unless modified.

    Following is the sample code what i am using in my project.

    HTML File

    script type="text/javascript">

    // Load XML

    var xml = new ActiveXObject("Microsoft.XMLDOM")

    xml.async = false

    xml.load("TableCd.xml")

    // Load the XSL

    var xsl = new ActiveXObject("Microsoft.XMLDOM")

    xsl.async = false

    xsl.load("TableCd.xsl")

    // Transform

    document.write(xml.transformNode(xsl))

    </script>

    XSL File to load combo-boxes

    <?xml version="1.0" encoding="ISO-8859-1"?>

    <xsl:stylesheet version="1.0"

    xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

    <xsl:template match="/">

      <html>

      <body>

        <h2>My CD Collection</h2>

        <table border="1">

          <tr bgcolor="#9acd32">

            <th>Title</th>

            <th>Artist</th>

          </tr>

    <xsl:for-each select="catalog/cd">

    <tr> 

     <td><xsl:attribute name="id"><xsl:value-of select="price"/></xsl:attribute><xsl:value-of select="title" /></td>

     <td><xsl:value-of select="artist" /></td>

    </tr>

    </xsl:for-each>

            </table>

      </body>

      </html>

    </xsl:template>

    </xsl:stylesheet>

     

  • This was removed by the editor as SPAM

  • Could it be the IE setting different one the two machine? Seems the cache is disabled on the xp machine.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply