So if you type "http://localhost/nav/template/sqltemp.xml" into the address bar 
of ie you get a view of the XML?

-- 

Joe (MVP - XML)

"Chris Kennedy" <ck001s7253nospam@b...> wrote in message 
news:OMFuF3XIFHA.2956@T......
> Could it be an issue with encoding the sql seems to output in "UTF-16"?
>
>
> "Chris Kennedy" <ck001s7253nospam@b...> wrote in message
> news:#x#JVVXIFHA.3196@T......
>> set xmlDoc = CreateObject("microsoft.xmldom")
>> set xslDoc = CreateObject("microsoft.xmldom")
>>
>> xmlDoc.async = false
>> xslDoc.async = false
>>
>>
>> 'xmldoc.load("http://localhost/nav/template/sqltemp.xml") - doesn't work
>> all's I get it is <?xml version="1.0" encoding="UTF-16"?><table></table>
>> 'xmldoc.load("nav.xml") - doesn't work
>> xmldoc.load(server.mappath("nav.xml")) - does
>> xsldoc.load(server.mappath("xsl.xsl"))
>>
>>
>> strout =  xmlDoc.transformNode(xsldoc)
>> response.write strout
>>
>>
>>
>>
>> "Joe Fawcett" <joefawcett@h...> wrote in message
>> news:eLkyhHXIFHA.4076@T......
>> > "Chris Kennedy" <ck001s7253nospam@b...> wrote in message
>> > news:eT6WXcWIFHA.276@t......
>> > > It must be my transformation. I will include the XML and XSL below but
>> the
>> > > save response returns the correct sql. It displays correctly when I
> pull
>> > > them from local files but not over http. When I do it over http I get
> a
>> > > blank page but when I look at the source code there is a table but no
>> > > content. It's as if the xsl can't find the nodes. What obvious thing
> am
>> I
>> > > doing wrong !!
>> > >
>> > The transform works for me so it must be something wrong in the way you
>> call it.
>> > Can you show the server side code?
>> >
>> > --
>> >
>> > Joe (MVP - XML)
>> >
>> >
>>
>>
>
>