28,391
社区成员
发帖
与我相关
我的任务
分享
..
<%
Dim objItem, objItem1,objItem2,objItem3,objItem4,ObjDOM
Set ObjDOM = Server.CreateObject("MSXML2.FreeThreadedDOMDocument.3.0")
Set objItem1 = ObjDOM.appendChild(ObjDOM.CreateElement("root"))
rs.open sql,conn,3,3
Do while not rs.eof
set objItem2 =objItem1.appendChild(ObjDOM.CreateElement("list"))
set objitem3 =objItem2.appendChild(ObjDOM.CreateElement("cardorderamount"))
If Not IsNull(rs("cardOrderAmount")) or rs("cardOrderAmount")="" Then
objItem3.appendChild(ObjDOM.createCDATASection(rs("cardOrderAmount")) )
Else
objItem3.appendChild(ObjDOM.createCDATASection(""))
End If
loop %>
...
<%
sXMLFile = "C:\xxx.xxx"
Set oDoc = CreateObject("Msxml2.DOMDocument")
With oDoc
.async = False
.validateOnParse = False
.preserveWhiteSpace = False
.resolveExternals = False
.load sXMLFile
If .parseError.errorCode <> 0 Then
sErrMsg = .parseError.errorCode & "|" &_
.parseError.srcText & "|" & .parseError.reason
Set oDoc = Nothing
Response.Write sErrMsg
Response.End
End If
' 用XPATH选节点
Set oNode = .selectSingleNode("/ROOT/ABC")
If Not (oNode Is Nothing) Then
oNode.text = "new value" ' 更改节点
End If
.save .url ' 保存
Set oNode = Nothing
End With
Set oDoc = Nothing
%>