Sorry, but this is just not working for me...
The first bit is fine and produces the display I need. I have a table of
stories and wish to allocate them to a page...I list the stories and
have a selection form to choose a page:
<@ROWS>
<TR VALIGN=TOP>
<TD>
<INPUT TYPE=HIDDEN Name=EditorialIDArray VALUE=<@COLUMN
'JobEditorial.ID'>><@COLUMN 'JobEditorial.ID'> </TD>
<TD>
<FONT FACE="Arial, Helvetica, sans-serif" SIZE="2"
COLOR="BLACK"><B><@COLUMN "JobEditorial.Tagline"></B></font>
</TD>
<TD>
<FONT FACE="Arial, Helvetica, sans-serif" SIZE="2"
COLOR="BLACK"><B><@COLUMN "JobEditorial.StoryDetails"></B></font>
</TD>
<TD>
<FONT FACE="Arial, Helvetica, sans-serif" SIZE="2"
COLOR="BLACK"><B><@COLUMN "JobEditorial.StoryWriter"></B></font>
</TD>
<TD>
<FONT FACE="Arial, Helvetica, sans-serif" SIZE="2"
COLOR="BLACK"><B>
<select name="AllocatedtoPageNo" Type="ARRAY">
<option value=0>
<@for stop=<@COLUMN 'JobNumbers.Pagination'>>
<option value="<@currow>"><@currow></@for>
</select>
</B></font>
</TD>
</TR>
</@ROWS>
If I display the two arrays produced by this on a results page they are
fine...
However, putting these arrays in the update produces the correct number
of results, but all with the same page number in the page number
field!!! What am I doing wrong?
____________________________
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 Simon Boddy
Sent: Tuesday, December 03, 2002 2:53 PM
To: Multiple recipients of list witango-talk
Subject: RE: Witango-Talk: updating multiple records
Hi Rick,
There is no need to loop to achieve this. You should give all your
checkboxes the same name, say myBoxes, then set the value attribute of
each checkbox to the database id of the corresponding record. You can
then use <@arg myBoxes type="array"> to retrieve an array of database
ids of checked boxes.
So just drag on an update action. In the top pane drag on your id
column, select the 'is in' operator, then type <@arg myBoxes
type="array">. In the update with values pane, just set your flag
column. Use <@numaffected> in the results to satisy your curiosity that
all records are being updated.
The fun starts when you want to process un-checks.
Good luck. Simon
--
_______________________________________________
Get your free email from http://www.graffiti.net
Powered by Outblaze
________________________________________________________________________
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
