import xml with asp

[boxhead]

I am trying to import some xml into an asp page for manuipulation. I have:

<%
Dim xmlDoc
Set xmlDoc=Server.CreateObject("Microsoft.XMLDOM")
xmlDoc.async=false  
xmlDoc.load(Server.MapPath("xmldata/2006-07_JUL-SEP.xml"))
xmlDoc.load(Request) 
If xmlDoc.parseError.errorcode<>0 then
	'error handling code
	Response.Write(xmlDoc.parseError.errorcode)
Else
	'proceed
	Response.Write("Everthing OK so far!")
End If
%>

I get :

error = -1072896680

is it obvious where i'm going wrong (the xml is valid)?

monkey

[bbolte]

first thing to do is open the xml file in IE, of there is a problem, it will let you know.

[bbolte]

and is that error being written by this line: Response.Write(xmlDoc.parseError.errorcode) or does it point to a different line in your script?

[boxhead]

done that - and run it through the w3c xml validator and everthing seems fine. seems to work if I remove the line:

xmlDoc.load(Request)

What I need is a good tutorial on how I can manipulate the data and use it in my asp code.

cheers

the response.write line

[bbolte]

http://msdn.microsoft.com/xml/default.aspx

there is an sdk/help file that can be download with all the code samples that you'd ever want. also maybe check out the "code samples" link.

[bbolte]

you also might check out here: http://www.4guysfromrolla.com/webtech/101200-1.2.shtml

[boxhead]

Cheers bill

I have already read the 4guysfromrolla article (the MSDN site keeps crashing on me!!!) and a few others, but they all seem to eaither use the xsl to display the entire xml data, or just write the whole lot out using asp.

I need far more control over the data, targeting the data in spacific elements. Treating it more like a recordset.

any ideas

cheers

[bbolte]

it's been a while since i've done it, but with MSXML you can target individual nodes or even return node collections. check into the sdk, not sure where it is on the site anymore. maybe do a google on the msxml sdk

[bbolte]

hey, here's an article on SP: http://www.sitepoint.com/article/mic...developers-1/2

[boxhead]

top man - i'll give it a read - cheers

[adrained]

I was curious as to why you even had that line
xmlDoc.load(Request)

The other load call is the on the one you want.

I see you are using the XMLDom so it uses pretty standard methods for accessing elements, tags and some
xmlDoc.getElementById
xmlDoc.getElementsByTagName
xmlDoc.childNodes
etc.

W3schools is always a great reference for this kind of stuff:
http://w3schools.com/dom/default.asp

[boxhead]

I have been reading the w3schools tutorials, but they are all in javascript and from what I can tell, I should be able to do the same thing in asp vbscript.

I am trying:

<%
Dim xmlDoc
Set xmlDoc=Server.CreateObject("Microsoft.XMLDOM")
xmlDoc.async=false  
xmlDoc.load(Server.MapPath("xmldata/myxmlfile.xml"))

If xmlDoc.parseError.errorcode<>0 then
	'error handling code
	Response.Write(xmlDoc.parseError.errorcode)
Else
	'proceed
	Response.Write(xmlDoc.getElementsByTagName("DataReturn"))
End If
%>

This gives the error: Missing Default property' - where am I going wrong. I'm sure once I get one basic thing to work, the rest will drop into place

cheers

[jimfraser]

Response.Write xmlDoc.getElementsByTagName("DataReturn").xml

[boxhead]

Response.Write xmlDoc.getElementsByTagName("DataReturn").xml

Object doesn't support this property or method: 'getElementsByTagName(...).xml'

[jimfraser]

How about
xmlDoc.selectSingleNode("DataReturn").xml

[boxhead]

fantastic!

How do I move down through the tree? ie:

<dataReturn>
<node></node>
</dataReturn>

How do i get to node?

cheers for your help

[jimfraser]

either

Set oMyNode = xmlDoc.selectSingleNode("dataReturn/node")
Response.Write oMyNode.xml

or if you need the DataReturn node first:

Set oDataReturn = xmlDoc.selectSingleNode("dataReturn")
Set oMyNode = oDataReturn.selectSingleNode("node")
etc

dont forget that xpath is case sensitive

[boxhead]

cheers - started to get to grips with it now

How do I get a list of attribute for a set of node (sorry, not sure of the language to use!)

so if i have:

<mynode>
<child attribute="x">45</child>
<child attribute="y">12</child>
</mynode>

I would like an array of the attributes or, better still, be able to loop through every child in a certain node and response.write the attribute value such as

for each child in mynode
response.write("attribute.value"&"</br>")
response.Write(xmlDoc.selectSingleNode("mynode/child[@attribute="&attribute.value&"]")
next

if you see what i mean

cheers

[jimfraser]

for each child in mynode.selectNodes("child")
response.write("attribute.value"&"</br>")
response.Write(child.getAttribute("attribute"))
next