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

2005-12-14 Thread Daniel Hertz
Aaron Koning wrote: Owen makes a good point. Check that you are using the [] in the HTML input variable for the checkboxes. Like: 1 2 3 4 Aaron On 12/13/05, Owen Jacobson <[EMAIL PROTECTED]> wr I'm not familiar with Cocoon, but I'd expect that to return only the first of the "approved

[SQL] 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