Samples - ASP JScript - XML Processing

Code Samples -- JScript
Example #8 - XML Processing
<%@ Language=JScript %>
<%
var oConn = Server.CreateObject("OpenX2.Connection.1")
var oCommand = Server.CreateObject("OpenX2.Command")
var sResult = "";
var sResultStr = "";
var sResultDoc = "";
var bError = false;
var sSQL = "SELECT * FROM titles";

try {
  oConn.Connect("ms_ox1");
  oCommand.Connection = oConn;
  oCommand.CommandText = sSQL;
  sResultStr = oCommand.XMLString;

  // Set stylesheet locations
  oCommand.Close();
  oCommand.CommandText = sSQL;

  var xmlProc;
  var xmlTmpl = Server.CreateObject("Msxml2.XSLTemplate");
  var xslStyle = Server.CreateObject("Msxml2.FreeThreadedDOMDocument");
  var styleFile = Server.MapPath("OpenX2.xsl");
  xslStyle.async = false;
  xslStyle.load(styleFile);
  xmlTmpl.stylesheet = xslStyle;
  xmlProc = xmlTmpl.createProcessor();
  // Get the XMLDocument from OpenX2
  xmlProc.input = oCommand.XMLDocument;
  if(xmlProc.transform())
  	sResultDoc = xmlProc.output;

}
catch(e) {
  bError = true;
  if(oCommand.ErrorCode != 0)
    sResult = "OpenX2 Command Error: " + oCommand.ErrorInfo + ". Error #" + oCommand.ErrorCode + " (" + oCommand.ErrorCodeEx + ")<br />";
  else
    if(oConn.ErrorCode != 0)
      sResult += "OpenX2 Connection Error: " + oConn.ErrorInfo + ". Error #" + oConn.ErrorCode + " (" + oConn.ErrorCodeEx + ")<br />";

  sResult += "ASP Error: #" + e.number + ". " + e.description + "<br />";
}

%>

<html>
  <head><title>OpenX2 Test #9 - XML Output</title></head>
<%
if(!bError) {
%>
  <XML id="source"><%=sResultStr%></XML>
  <XML id="style" src="openx2.xsl"></xml>
  <SCRIPT event="onload" for="window">
    showResult.innerHTML = source.transformNode(style.XMLDocument);
  </SCRIPT>
<%
}
%>
  <body>
<%
if(!bError) {
%>
    <h1>Server-Side XMLDocument Processing</h1>
    <div><%=sResultDoc%></div>
    <h1>Client-Side XML-Island (String) Processing</h1>
    <div id="showResult"></div>
<%
} else {
%>
  <div><%=sResultDoc%></div>
<%
}
%>
  </body>
</html>