Hi All
Has anyone any code / ideas on the following.
I have a list of 29 records. For each record, I have a dropdown with 3
options Yes, No and Apologies.
Will need to be able to go through each record and select either one of the
options, select
save button once and have the 29 records inserted all at once.
1. Below, i'm building my array, using a Search action
<@Rows>
<@ASSIGN Name="User$Cllr_Id" Value="<@COLUMN
'TblCllrGroups.CllId'>">
<@ADDROWS ARRAY="user$Councillor_Id" VALUE=@@user$Cllr_Id>
<@Assign count value=<@calc expr='@@count + 1'>>
</@rows>
Count Total Records :<@var count><BR>
2. I then have a For action looping from 1 to <@var count>
3. For each of the 29 records above, I need to see which option has been
selected
4. Within the For loop I have a Search action with the below.
<@ASSIGN i value=<@calc expr='@@user$i + 1'>>
<@assign user$tempRefID <@VAR Councillor_Id[@@user$i,1]>>
Cid:@@tempRefId<BR>
Count:@@i<BR>
5. I also have in the For loop 3 If statements, If Yes, ElseIf No and
ElseIf Apologies
It is not picking up on the option selected within the dropdown for each
record or the Cid (@@tempRefId). I'm inseting value 1 for Yes, 0 for No and
-1 for Apologies. The only value being entered is the value of the first
record on the list.
>From the above can anyone see where i'm going wrong?.
Thanks
Sean Mulligan
I.T. Development Team
Meath County Council
Navan
Co. Meath
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
