I am attempting to pull XML from an external site using an ASP page which loads the XML then loads the XSL for formatting. I've tried this with a local XML file and it works great. When I try to access an external XML file via a url it won't return data. Any ideas? Here is my code:
<%@ Language=VBScript %>
<%
startTable="<table bgColor=#f0f8ff border=0 cellPadding=2 WIDTH=100% cellSpacing=0><tr><td bgcolor=midnightblue><font color=white face=Arial size=2><strong>"
startTableEnd="</strong></font></td></tr>"
endTable="</table>"
'Load the XML
set xml = Server.CreateObject("Microsoft.XMLDOM"
xml.async = false
xml.load("
'Load the XSL
set xsl = Server.CreateObject("Microsoft.XMLDOM"
xsl.async = false
xsl.load(Server.MapPath("home_news.xsl")
'headline
newsName="Primedia Insight Newswire"
News=replace(xml.transformNode(xsl),"'",""
News=replace(News,"</br>",""
Response.Write(startTable&newsName&startTableEnd&News&endTable)
%>
<%@ Language=VBScript %>
<%
startTable="<table bgColor=#f0f8ff border=0 cellPadding=2 WIDTH=100% cellSpacing=0><tr><td bgcolor=midnightblue><font color=white face=Arial size=2><strong>"
startTableEnd="</strong></font></td></tr>"
endTable="</table>"
'Load the XML
set xml = Server.CreateObject("Microsoft.XMLDOM"
xml.async = false
xml.load("
'Load the XSL
set xsl = Server.CreateObject("Microsoft.XMLDOM"
xsl.async = false
xsl.load(Server.MapPath("home_news.xsl")
'headline
newsName="Primedia Insight Newswire"
News=replace(xml.transformNode(xsl),"'",""
News=replace(News,"</br>",""
Response.Write(startTable&newsName&startTableEnd&News&endTable)
%>