replace single child with value

Kabe · April 13th, 2004, 07:01 AM

have e.g. this xml
<sqlpart>AND (y.Goedkeurder = <var id="personeelslid_id"/> )</sqlpart>

at the end <var .../> has to be replaced by a value and xml must become this:
<sqlpart>AND (y.Goedkeurder = 250 )</sqlpart>

how to do ?

thx!
kristof

pgtips · April 14th, 2004, 09:11 AM

so you want to replace a node with just text? Try this:

Code:

    ' this is the text you want to put in place of the var node
    Dim xText
    Set xText = DomObject.createTextNode("250")

    ' this is the var node to be replaced
    Dim xTempNode
    Set xTempNode = DomObject.selectSingleNode("sqlpart/var[@id='personeelslid_id']")

    ' this is the replacement
    DomObject.documentElement.replaceChild xText, xTempNode