General

Re: Programmatically Adding Data to Table Rows

Doug Myers — Tue, 25 Apr 2006 20:50:50 GMT

Thanks, Greg. It's sometimes tough to see the forest for the trees.

Re: Programmatically Adding Data to Table Rows

Greg Collins — Tue, 25 Apr 2006 20:46:02 GMT

Your row.selectSingleNode() XPath is the problem. You are giving it an absolute XPath from the top of your schema instead of a relative XPath staring from the node itself.

It should probably be something like row.selectSingleNode("my:field1").text = ...

Programmatically Adding Data to Table Rows

Doug Myers — Mon, 24 Apr 2006 17:57:28 GMT

The following VBScript produces new table rows but unfortunately the data is simply re-written over the first row (node). I am sure there is something obvious that I am missing, but I could use some help identifying the problem. Here's a slice of the code:

(Note: rsObj is a recordset from SQL)

insideLoop = False
i=0

Do Until rsObj.EOF
If insideLoop then
XDocument.View.ExecuteAction "xCollection::insert", "group2_201"
End if

set nodesDetail = XDocument.DOM.selectNodes("/my:myFields//my:group2")

set row = nodesDetail.item(i)

row.selectSingleNode("/my:myFields//my:field1").text = Flds(1).Value

insideLoop = True
i = i + 1
rsObj.MoveNext
Loop

The data is successfully obtained from an SQL database and is in the array "Flds." My test case produced 5 rows (to match the 5 Flds values) but only the first row contained the last result.