xml document formats and VB MSXML2

[vbmom]

I can use Visual Basic's MSXML2 objects to make an xml file like this:

<root>
<record>
<JobID>126</JobID>
<Session>1</Session>
<WorkStation>LARCHMONT</WorkStation>
<JobSource>dbaexchis\</JobSource>
</record></root>

But how do I use that library to make a file like this:

<root>
<record JobID="126" Session="1" WorkStation="LARCHMONT" JobSource="dbaexchis\">
</record></root>

What I desire, is it considered "attribute-centric"?

[JoshT]

Use the XML Nodes setAttribute method (or getAttribute to read).

Set xmlFolder = xml.createElement("source")
xmlFolder.setAttribute "folder", strFolder

[vbmom]

JoshT, I do not have .setAttribute as an intellisense choice when I do what you suggested. I also don't understand what you suggested.

[The Hobo]

Would you like to borrow my copy of "An Idiots Guide to Understanding JoshT?"

[JoshT]

Eh Heh...

'root is the XML DOMDocument object that corresponds to your root tag
Dim root as MSXML2.DOMDocument
Dim xmlRecord as MSXML2.IXMLDOMElement
'code for opening up the xml document and setting root goes here
 
Set xmlRecord = root.createElement("record") 'make the <record /> tag
xmlRecord.setAttribute "JobID", "126"
xmlRecord.setAttribute "Workstation", "LARCHMONT"
'set the rest of the attributes...
 
root.AppendChild xmRecord 'add the new <record /> to the xml file

[vbmom]

I had to tweak that a bit but I got your point. I just don't want everything to be attributes. I want a new node for each record, with attributes beneath it. But you have me an idea, perhaps it's the way I'm writing the nodes to the document. Thanks for your help.

[vbmom]

What I had to do was

Set xRecordNode = xDoc.CreateNode(NODE_ELEMENT,"record","")
set xRecordNode = xParentNode.appendChild(xRecordNode)

' And do this for each "field" of the record
Set xFieldNode = xDoc.CreateNode(NODE_ELEMENT,"JOBId","")
set xFieldNode = xParentNode.appendChild(xFieldNode)