Re: [GENERAL] Multi-row update w. plpgsql function

2005-12-14 Thread Daniel Hertz
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 Her

[GENERAL] Multi-row update w. plpgsql function

2005-12-13 Thread Daniel Hertz
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