It's understandable. We all pretty much started with the tools and it's difficult to visualize something from a text description.
Looking at it from the builder's way of doing things, you'll have a set of IF/ELSEIF actions (IF Form, ElseIF Update, etc.). Drag a FOR Loop action (which looks like '[' only with an open green box inside of it) inside of the ElseIF Update action. Move the Update action inside of the FOR Loop action. I've attached an example which illustrates the idea. Note that I haven't actually tested this and I don't have your database structure so you will have to tweak it a little. Hope this helps, Steve Smith Oakbridge Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.oakbridge.ca > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Rick Haden > Sent: December 3, 2002 9:04 AM > To: Multiple recipients of list witango-talk > Subject: RE: Witango-Talk: updating multiple records > > > Thanks Steve...I understand...to a point...sorry to be so thick, but how > do you loop and update or insert? - I am still using the tools... do I > need to use Direct DBMS? > > ____________________________ > Rick Haden > Director - IS/IT > Trident Communications > 3 Selsdon Way > City Harbour > London > E14 9GL > UK > Tel: +44 20 7536 8924 > Fax +44 20 7536 8999 > www.tridentcommunications.net > Connecting Ideas <> Delivering Results > > This email from Trident Communications is for the attention of the > addressee only. It may contain information that is confidential and/or > privileged and should not be reproduced and/or distributed to any other > person without the consent of Trident. > _______________________ > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Steve Smith > Sent: Tuesday, December 03, 2002 11:20 AM > To: Multiple recipients of list witango-talk > Subject: RE: Witango-Talk: updating multiple records > > The one word answer is ... loops. > > What you need to do is create loops both on the form and in the > processing > of the update action. The first loop is easy because it already exists > in > the form of the <@ROWS> loop. You need to add something to uniquely > identify > each field. Inside the <@ROWS> loop, instead of calling the update field > paid (an example), call it paid<@CURROW> which will produce paid1, > paid2, > etc. This gives you a set of unique arguments, one for each resultset. > Actually you'll need two fields, one of which contains the primary key > so if > the primary key for the table is 'studentid' and the field you wish to > change is 'paid' you'd have studentid<@CURROW> and paid<@CURROW> as the > names of your fields. The first will probably be a hidden field. You'll > also > need another single hidden field which contains the number of rows to > process. > > <FORM METHOD=POST ACTION="<@CGI><@APPFILE>"> > <@ROW> > <INPUT TYPE=HIDDEN NAME="studentid<@CURROW>" VALUE="<@COLUMN > tablename.studentid>"> > <INPUT TYPE=CHECKBOX NAME="paid<@CURROW>" VALUE="1"> > </@ROW> > <INPUT TYPE=HIDDEN NAME="studentnumrows" VALUE="<@NUMROWS>"> > <P> > <INPUT TYPE=SUBMIT NAME="Submit" VALUE="Submit"> > <INPUT TYPE=RESET VALUE=Reset> > </FORM> > > This gives you a pair of fields, one for each row in your results. It > also > gives you another single hidden field which contains the number of rows > to > process. > > In the update section, add a FOR action with 'To:' value set to <@ARG > studentnumrows> and use l_counter as the Counter Variable for this > action. > This will cause the update to be peformed x number of times where x is > the > number of rows processed. > > Put your update action inside of this loop and for the value of the > 'select > rows matching these columns' use <@ARG NAME="studentid<@VAR > NAME='local$l_counter'>">. For the value of the 'Update them with these > values' use <@ARG NAME="paid<@VAR NAME='local$l_counter'>">. Each time > through the FOR Loop action, l_counter will get incremented > automatically so > it will process studentid1/paid1, studentid2/paid2, studentid3/paid3, > until > it reaches studentnumrows which was the original number of records. > > Hope this helps, > > Steve Smith > > Oakbridge Information Solutions > Office: (519) 624-4388 > GTA: (416) 606-3885 > Fax: (519) 624-3353 > Cell: (416) 606-3885 > Email: [EMAIL PROTECTED] > Web: http://www.oakbridge.ca > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of Rick Haden > > Sent: December 3, 2002 4:39 AM > > To: Multiple recipients of list witango-talk > > Subject: Witango-Talk: updating multiple records > > > > > > Wish I knew this program better...is there a way of updating a list of > > records all at once...ok...I do a search and get a resultset...I need > to > > go down the list and tick a checkbox on a few of them then click a > > button to update all those checked. But when I click the button all I > > get is the first one...I am obviously missing something very > fundamental > > > > ____________________________ > > Rick Haden > > Director - IS/IT > > Trident Communications > > 3 Selsdon Way > > City Harbour > > London > > E14 9GL > > UK > > Tel: +44 20 7536 8924 > > Fax +44 20 7536 8999 > > www.tridentcommunications.net > > Connecting Ideas <> Delivering Results > > > > This email from Trident Communications is for the attention of the > > addressee only. It may contain information that is confidential and/or > > privileged and should not be reproduced and/or distributed to any > other > > person without the consent of Trident. > > _______________________ > > > > > > > > > ________________________________________________________________________ > > TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] > > with unsubscribe witango-talk in the message body > > > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body
multipleupdates.taf
Description: Binary data
