Loading XML file into a RecordSet using ASP????

[notrut]

Hi,

I was just wondering if it is possible to load a XML file into a Recordset using ASP????

Any help would be greatly appreciated!!

 

[Cagliostro]

yes, you should use MSXML parser to read XML.

Ion Filipski

 

[notrut]

Sounds good to me, but I'm not sure how to do that since I'm pretty new to XML.

Right now, I'm loading the XML file into an array by using the following code:

Set xfdoc = server.CreateObject("MSXML2.FreeThreadedDOMDocument&quot
xfdoc.async = False
xfdoc.Load (Server.MapPath("BUFiles.xml&quot)
Set xfdocelem = xfdoc.documentElement

If xfdocelem Is Nothing Then
Response.Write "ERROR: Nothing in file:" & err.number & ": " & err.description
ELSE

Redim astrArrayNode(3, xfdocelem.ChildNodes.length)

If xfdocelem.ChildNodes.length > 1 Then
For Each xfdocnode In xfdocelem.ChildNodes
intIndexI = intIndexI + 1
If Len(Trim(xfdocnode.nodename)) > 0 Then
astrArrayNode(0,intIndexI) = xfdocnode.nodename 'Name of File
astrArrayNode(1,intIndexI) = xfdocnode.getAttribute("OldURL&quot 'Old URL
astrArrayNode(2,intIndexI) = xfdocnode.getAttribute("NewURL&quot 'New URL
End If
Next
end if
End If

Is there an easy way to modify this so it will load into a recordset??

 

[Cagliostro]

I think this code is enough easy to use and to understand. Only you need now, is to know how to use ADO recordet.

Ion Filipski

 

[ChainsawJoe]

But isn't there a way to load an xml file directly into a recordset? something similar to

set oRs = server.createobject("adodb.recordset")
fXML = server.mappath("people.xml")
oRs.open fXML, adPersistXML

or something? cos this is doing my head in. All I want to do is use a dead simple xml lookup file (<item><value>1</value><name>bob</name></item> - that kinda thing) and query it to get a particular <name>.text given a particular <value>.text value.

I know all about the

load

ing and

selectNodes

stuff using an XML Dom Object, but if anyone can help with either loading the xml into a recordset, or query the XML dom in this fashion I'd muchos appreciate it...


--------------------------------------------------

http://www.chainsawjoe.com

- better than toast.
Penguins - better than

http://www.chainsawjoe.com

--------------------------------------------------

 

[ChainsawJoe]

OK - update. I've found that this kinda works;

oRs.Open sFilePath, "Provider=MSPersist;", adOpenForwardOnly, adLockReadOnly, adCmdFile

but I get the error

Source XML is incomplete or invalid

The source xml is just fine n dandy, but is there a particular style that ADO requires for this to work?

--------------------------------------------------

http://www.chainsawjoe.com

- better than toast.
Penguins - better than

http://www.chainsawjoe.com

--------------------------------------------------