Newbie Questions

Re: selectSingleNode for all records in data source

PJagger — Mon, 28 Jul 2008 05:06:12 GMT

Hey Josh,

That did it! Thank you! & Thank you Hilary! You have both helped me enormously!

Regards - Phil

Re: selectSingleNode for all records in data source

JoshuaWeir — Mon, 28 Jul 2008 04:29:53 GMT

Try doing this:

var Records = XDocument.DOM.selectNodes

("/my:myFields/my:Itemisations/my:ItemisationsTable");

for (var i=0; i < Records.length; i++) { FileObject.Write(Records[i].selectSingleNode("my:AllocationDetails/my:PaymentMethod").text + "\t");

//…then repeat this for all the other fields except the last one …..

//..then for the last one ensure you put the newline characters instead of the tab:

FileObject.Write(Records[i].selectSingleNode("my:AllocationDetails/my:YourLastField").text + "\r” + “\n”);

}

Re: selectSingleNode for all records in data source

PJagger — Mon, 28 Jul 2008 01:00:03 GMT

Okay Hilary,

Tried your suggestion, at first it was not writing anything, however, I replaced [i] in the var blah line with 0 then 1 and yes it was writing the selected row accordingly. I changed it back to [i] and its working!?? Thank you big time!

I am hampered by my next step however, I am trying to write a row of fields from a repeating table separated by tabs ("\t") and then start a new line ("\r" + "\n") before the next row of data is written and so forth In others words, a tab delimited text file output. I can't seem to enable my var blah to include the tab and another field.

Please advise.

Regards - Phil

Re: selectSingleNode for all records in data source

Hilary Stoupa — Sun, 27 Jul 2008 23:59:53 GMT

Oh, sure. I mean the code above should read thus:

var Records = XDocument.DOM.selectNodes("/my:myFields/my:Itemisations/my:ItemisationsTable");

for (var i=0; i < Records.length; i++)

{

var blah = Records[i].selectSingleNode("my:AllocationDetails/my:PaymentMethod");

//note that the below I have used for debugging to verify the value of the field.....

//FileObject.Write(blah.text + "\t");

}

Because, you see, your variable called Records refers to the ItemisationsTable node. So, as you iterate through, you want to be setting your new variable to the PaymentMethod node that belongs to the record node you are currently looking at....

Re: selectSingleNode for all records in data source

PJagger — Sun, 27 Jul 2008 23:00:59 GMT

Hi Hilary

Thanks for your reply. I still need further directions. What do you mean by so: "my:AllocationDetails/my:PaymentMethod"?

Appreciate your help

Phil

Re: selectSingleNode for all records in data source

Hilary Stoupa — Sun, 27 Jul 2008 13:41:00 GMT

For "blah" you are iterating through all the records nodes and then going back up to your main node to select the value -- which always returns the first value. The selectSingleNode for that variable should be from Records[i], so: "my:AllocationDetails/my:PaymentMethod"

selectSingleNode for all records in data source

PJagger — Sun, 27 Jul 2008 07:47:28 GMT

I want to get the value of a field for all records in a repeating table. In my current repeating table there are 3 records.

I use the following code to try to retrieve the value of the field for each record but it only ever gets the value of the 1st record in the repeating table:

var Records = XDocument.DOM.selectNodes("/my:myFields/my:Itemisations/my:ItemisationsTable");

for (var i=0; i < Records.length; i++)

{

var blah = Records[i].selectSingleNode("/my:myFields/my:Itemisations/my:ItemisationsTable/my:AllocationDetails/my:PaymentMethod");

//note that the below I have used for debugging to verify the value of the field.....

//FileObject.Write(blah.text + "\t");

}

What am I doing wrong here? It is only ever showing the field value of the 1st record in the repeating table???