be sure if you are using DBMS that on the results tab the array radio option is highlighted.
-----Original Message----- From: Sean Mulligan (Information Technology) [mailto:[EMAIL PROTECTED] Sent: Monday, February 02, 2004 7:12 AM To: '[EMAIL PROTECTED]' Subject: Witango-Talk: Array Problem! 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
