General

Re: Comparing rows of a repeating section or table

Swanee — Thu, 03 Jan 2008 22:37:48 GMT

Worked like a charm. Thanks!

Re: Comparing rows of a repeating section or table

Matt Faus — Mon, 17 Apr 2006 16:26:45 GMT

Hi Marien,

The code example given is in C#.NET, which is managed code. You are using JScript. The equivalent in JScript would be as follows:

var oNodeList = XDocument.DOM.selectNodes("my:myFields/my:group1/my:group2");

var oNode;

while( (oNode = oNodeList.nextNode()) != null )
{
if( oNode.nodeType == 1 )
{
var oField = oN.selectSingleNode("my:field1");
XDocument.UI.Alert(oField.text);
}
}

See this link for further info on nodeType:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/039aa2c8-2414-43e8-82cf-3e056eebb2f4.asp

Hope this helps!

Re: Comparing rows of a repeating section or table

Mairen — Mon, 17 Apr 2006 14:09:43 GMT

I have a similar problem, but when I tried to use the example code on a new form I got the following message:

quote:
InfoPath cannot open the selected form because of an error in the form's code.
The following error occurred:

Expected ';'
File:script.js
Line:26
IXMLDOMNodeList oNodeList = thisXDocument.DOM.selectNodes("my:myFields/my:group1/my:group2");

There's not actually any missing ;s as far as I can tell. Any idea what might cause this? Where did you put your code? Behind a button?

Thanks.

Re: Comparing rows of a repeating section or table

Matt Faus — Mon, 31 Oct 2005 14:09:02 GMT

Why do you have to put in "if (oNodeList.length>0)" - shouldn't the foreach only run if that condition is true? It seems like you're stating something explicitly that is implied in the foreach statement... I'm confused.

---------------
Matt Faus

Re: Comparing rows of a repeating section or table

franck — Sun, 30 Oct 2005 23:29:11 GMT

Hi,

To loop through your nodes, use something like:

IXMLDOMNodeList oNodeList = thisXDocument.DOM.selectNodes("my:myFields/my:group1/my:group2");
if (oNodeList.length>0)
{
foreach (IXMLDOMNode oN in oNodeList)
{
if( oN.nodeType == DOMNodeType.NODE_ELEMENT )
{
IXMLDOMNode oField = oN.selectSingleNode("my:field1");
thisXDocument.UI.Alert(oField.text);
}
}
}

Regards,

Franck Dauché

Re: Comparing rows of a repeating section or table

qwer — Sun, 30 Oct 2005 22:34:31 GMT

Thanks franck. I was hoping for an easier way out. But I am exploring your suggestion. Can you also tell me the syntax on how to check whether I have reached the last row of the repeating table as I am implementing a FOR or do-until loop? Thanks again!

Re: Comparing rows of a repeating section or table

franck — Fri, 28 Oct 2005 13:10:35 GMT

Hi,

Did you try to use code to do this?
You can refer to a specific field on the nth row of your table using code such as:
IXMLDOMNode oNode = thisXDocument.DOM.selectSingleNode("/my:myFields/my:group1/my:group2[n]/my:field1");

Hope that it helps.

Regards,

Franck Dauché

Comparing rows of a repeating section or table

qwer — Fri, 28 Oct 2005 05:30:34 GMT

Hi,

My form has a repeating section that allows users to insert rows. Each row requires a FromDate and a ToDate. What is the easiest way to evalutes the values from one row to another row? eg, I want to validate the rows so that no FromDate equals to another FromDate on another row. Thanks!