It is possible load a node of a xmlDocument in an adodb recordset?
Printable View
It is possible load a node of a xmlDocument in an adodb recordset?
:confused: :confused: Not sure what you mean exactly.
You have reason. I will try to explain the problem better.
Imagine I have a xml file like this:
<?xml Version="1.0"?>
<extract>
<title1>
…
</title1>
<title2>
…
</title2>
<lines>
<line>
…
</line>
<line>
…
</line>
<line>
…
</line>
</lines>
</extract>
..and I want to load into a recordset only the ‘lines’ node. How can I do it?
I don't think you can just load part of an XML doc into a recordset. Also, as far as I know, to load an xml doc intop a recordset, there's certain meta data the recordset needs which defines the data types and shape of the data.
If all you need is the one node, why not use the XML DOM object or a SAX parser? It would be much easier and with less overhead than with a recordset.