Aaron Koning wrote:
This might be easier to use this SQL:
UPDATE message_table SET status = 'A' WHERE mid IN (1,2,3);
The following might work for Cocoon (never used it):
UPDATE message_table SET status = 'A' WHERE mid IN
();
Aaron
On 12/13/05, Daniel Hertz <[EMAIL PROTECTED]> wrot
This might be easier to use this SQL:
UPDATE message_table SET status = 'A' WHERE mid IN (1,2,3);
The following might work for Cocoon (never used it):
UPDATE message_table SET status = 'A' WHERE
mid IN ();
Aaron
On 12/13/05, Daniel Hertz <[EMAIL PROTECTED]> wrote:
Given a set of checkb
Given a set of checkbox values that are submitted through an html form,
how do you loop through the submitted values to update more than one row
in a table?
Imagine a table called 'message_table':
mid | message | status
+-+---
1 | Text1 | H
2 | Text2 | H
3 | Text