Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

loading an XML file from SQL2000

Status
Not open for further replies.

Torp23

Programmer
Jun 13, 2002
32
0
0
US
Why can't I substitute an XML file being produced from SQL2000 for one that is hard-coded? I used the 'EXPLICIT' function to make sure all the items are elements and I ran it in a browser by itself so that I am sure the format matches the hard-coded file exactly. But when I run the ASP page to load it into the DOM with the line:

source.load(xmlurl)

it will not read the data even though no error is returned. If I hand-type in the records into a text file, name it with an XML extension and reference that in the call, it reads it just fine.

What is up with that?????!!!

Scott
 
The loadXML() method of the MSXML DOM object should do the trick. I assume that you are using the MSXML 4.0 SDK.
Bryan Wilhite
info@songhaysystem.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top