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

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

2005-12-14 Thread Magnus Hagander
> > Imagine a table called 'message_table': > > > > mid | message | status > > +-+--- > > 1 | Text1 | H > > 2 | Text2 | H > > 3 | Text3 | H > > 4 | Text4 | H > > > > A web page presents the user with all messages flagged with > 'H'. User > > checks m

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

2005-12-14 Thread Aarni Ruuhimäki
Hi, If your checkboxes are like input type="checkbox" name="approved" value="1" input type="checkbox" name="approved" value="2" input type="checkbox" name="approved" value="3" input type="checkbox" name="approved" value="4" and 1, 3 and 4 are checked your form data will be approved=1,3,4 Then y

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

2005-12-13 Thread Aaron Koning
Owen makes a good point. Check that you are using the [] in the HTML input variable for the checkboxes. Like: 1 2 3 4 AaronOn 12/13/05, Owen Jacobson <[EMAIL PROTECTED]> wrote: Daniel Hertz wrote:> Given a set of checkbox values that are submitted through an> html form,> how do you loop t

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

2005-12-13 Thread Owen Jacobson
Daniel Hertz wrote: > 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 |

[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