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)
> >
> >
>
>