"Chris Kennedy" <ck001s7253nospam@b...> wrote in message 
news:OX1t2zCIFHA.3444@T......
>I have an SQL Server outputting some XML - when I put the XML in a text file
> and load it via the C drive it loads. When I try it over http the page
> doesn't display any data. I have playing around with streams but I can't get
> it to work. Can anyone point me in the right direction
>
>
> set xmlDoc = CreateObject("microsoft.xmldom")
> set xslDoc = CreateObject("microsoft.xmldom")
> set strXML = CreateObject("adodb.stream")
>
> xmlDoc.async = false
> xslDoc.async = false
>
> strXML.open
> strXML.WriteText "http://localhost/nav/template/sqltemp.xml", adWriteChar
>
> xmldoc.load(server.mappath("nav.xml")) - this works
> xmldoc.load(strXML.ReadText) - this doesn't
> xsldoc.load(server.mappath("xsl.xsl"))
>
> strout =  xmlDoc.transformNode(xsldoc)
>
>
You don't need to use a stream if the url returns xml, just use 
domdocument.load(url) or xmlhttp class.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/dom_reference.asp?frame=true


-- 

Joe (MVP)