![]() |
![]() | ![]() | ![]() | Altova Mailing List Archives>Archive Index >microsoft.public.xml Archive Home >Recent entries >Thread Prev - Re: Read xml from SQL server [Thread Next] Re: Read xml from SQL serverTo: NULL Date: 3/5/2005 12:46:00 PM That's right.
"Joe Fawcett" <joefawcett@h...> wrote in message
news:OgFrr9XIFHA.2740@T......
> 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)
> >> >
> >> >
> >>
> >>
> >
> >
>
>
| ![]() | ![]() | ![]() |
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | |||||
|
