Hi Sean, The attached demonstrates how you can do multiple updates - It is the same as what Dan mentioned but this can be run as is and so you should be able to see how it works pretty quickly. ( I have just simulated the search and insert part)
Basically the drop down list is identified by the record id of that row and this is then passed through as the argument name. If I can be of any further assistance please contact me. Fergal ----- Original Message ----- From: "Sean Mulligan (Information Technology)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 02, 2004 11:12 PM 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
multiple.taf
Description: Binary data
