asked on

Is there a method to read a XML file in IExplorer that doesn't involve Msxml2.DOMDocument?

Hello Experts:

I'm the fellow that has been trying to read and display 30 records making up the Dow Industrial Index. I thought this was going to be a lot easier then it's turn out.

It seems that I am getting bogged down in just listing the beginning and ending prices of these stocks in a right juistified mode. Assuming that I overcome this problem (which no one seems to be able to solve), the next problem is going to be to limit each page to 15 records.

Now these problems seem to be monumental and it makes me wonder how other folks are succeeding in their respective projects if I can't even display a few records. This leads in turn leads me to think that maybe the problem is relying on Msxml2.DOMDocument and Msxml2.FreeThreadedDOMDocument to pull this off.

Should I be using another ActiveX Data Object here that is ADO like - that would give me better control over the recordset so that, for example, it would handle all the issues associated with paging, etc.

Am I on the right track here? Is Msxml2.DOMDocument the most up-to-date thing out there if I am willing to make my web application only compatible with IE 6.0 and 7.0?

Thanks for your help in advance.

Gordo

sh0e

The most recent version is Msxml2.DOMDocument.6.0
Msxml.DOMDocument
Msxml2.DOMDocument.3.0
Msxml2.DOMDocument.4.0

You want to use the SAX interface, which processes chunk by chunk, so it is faster.

Gertone (Geert Bormans)

Hi Gordon,

The only and best way for dealing with XML in Internet Explorer is using the MSxml2.DOMDocument, as I showed you before.
As sh0e rightly says, you could use a more modern version of the activeX.
It doesn't matter too much, for the things you are doing

check which version of msxml you have installed. With IE7, I believe you would have msxml6, if not, you can install it manually
Instead of my earlier
var oXML = new ActiveXObject("Msxml2.DOMDocument");
var oXSL = new ActiveXObject("Msxml2.FreeThreadedDOMDocument");
var oTmpl = new ActiveXObject("Msxml2.XSLTemplate");
do this
var oXML = new ActiveXObject("Msxml2.DOMDocument.6.0");
var oXSL = new ActiveXObject("Msxml2.FreeThreadedDOMDocument.6.0");
var oTmpl = new ActiveXObject("Msxml2.XSLTemplate.6.0");

(I can also send you code that simply checks which version is installed and picks the most recent one on your machine)

Do you require your code to be used by others? Or just on your machine.... I can make everything you have done sofar more or less browser independent as well, if you need it to be that way.

About SAX, depending on how many records you are pulling from the Excel... I don't think you need to get into SAX for processing, it would just add to the complexity. We can see later

About succesfull projects? I have done plenty similar to what you are trying to do.
I suggest that you pull in all the records and we can then organise the paging from the XSLT and the JavaScript... piece of cake.

You might realise at some point that you need more than the help you can get from subsequent EE questions.
Just write me an email then, we can work something out (email is on my profile)

cheers

Geert

ASKER CERTIFIED SOLUTION

Gertone (Geert Bormans)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Gertone (Geert Bormans)

and the HTML

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Dow Jones for Gordon</title>
    <script language="javascript">
			function TransF(rec1,p) 
				{
			       // create and load the XML document
			       var oXML = new ActiveXObject("Msxml2.DOMDocument");
			       oXML.async = false;
			       oXML.load("Dow_Stocks_Data.xml");
			       // create and load the XSL document
			       var oXSL = new ActiveXObject("Msxml2.FreeThreadedDOMDocument");
			       oXSL.async = false;
			       oXSL.load("Dow-Stocks.xsl");
			       // create the template processor
			       var oTmpl = new ActiveXObject("Msxml2.XSLTemplate");
         		 oTmpl.stylesheet = oXSL;
		         oProc = oTmpl.createProcessor();
		         oProc.input = oXML;
		         // add parameters
		         oProc.addParameter("page", p);
		         oProc.addParameter("first", rec1);
		         // make the transform
						 oProc.transform();
         		 var resHTM = oProc.output;
         		 // write the transformation result as the inner HTML of the div
         		 document.getElementById("RB").innerHTML = resHTM;
        }
		</script>
</head>
 
<body>
	<div>
		<button type="SUBMIT" name="Button1" value="Button1" onclick="TransF(1,15);">
			<img src="button.gif"/>
		</button>
	</div>
	<div>
		<div id="RB"></div>
	<div>
</body>
</html>