Highlighted

loop through the records from xml data file in formCalc script

Avatar

11-12-2008

Hi
I have a xml data file which contains a sequence of repeating applicant data like given below


US





II


CEO
Mr

111111111

0000000111
GuarantorA


111

IN
11111





WILLIAMS1
R3

KENNETH1
City1GU
PA
1934-03-14
abcdefgh@xyz.com

GU

R

113 Lazlo LaneCA
Suite 3500CA
OaklandCA
TX
11345
AL


I want to assign a textfield with a value based on the value of coap_flag.
So i need to loop through all the record and check the value of coap_flag and then assign the textfield a value based on that.

I am new to Adobe livecycle...Please help me how it can be done.

I have developed something like this
foreach Item in ($record.applicant[*].coap_flag) do
test.value=Item
if(test.value=="MA")then
concat($record.applicant.first_name,$record.applicant.middle_name)endif
endfor