Re: help creating sqlalchemy/sqlsoup code for sql query

Thank you for shedding some light on what is happening. However I am 
still a little confused. Does that mean that I need to display a 
separate page for each row of the table in order to have a delete and 
update button associated with the row? What other way/s would you 
suggest of doing the same thing?
Thanks very much, sorry to keep bothering you.
MJ

Jonathan Ellis wrote:
> On Tue, 10 Oct 2006 15:57:29 +0100, "Mary Jane Boholst"
> <[email protected]> said:
>   
>> When I add the id column to the table which I am displaying, the rows
>> have the 
>> correct id associated with them, however when I try to delete a row the
>> first 
>> row displayed is deleted. 
>> I attach the relevant code. If anyone could shed light on what is going
>> on and 
>> what I am doing wrong I will be very grateful.
>>     
>
> Forms have a single "namespace," every time your loop executes, you
> create a hidden variable, but only one of those values is actually used
> in the handler.  If you want to take that approach, you need a separate
> form for each time through the loop.
>
> You can also clean up your loops, you don't need the "r" variable.  like
> this
>
> [[for item in lists: {]]
> <f:form>
> <tr>
> <td><f:hidden name="item_id" value="=item.id" />
> <td><f:text name="item_id" value="=item.id" size =4 /></td>
> <td><f:text name="day" value="=item.day" size =2 /></td>
> <td><f:text name="course" value="=item.course" size =5 /></td>
> <td><f:text name="start" value="=item.starttime" size =5 /></td>
> <td><f:text name="end" value="=item.endtime" size =5 /></td>
> <td><f:text name="title" value="=item.title" size =80 /></td>
> <td><f:text name="tutor" value="=item.givenby" size =30 /></td>
> <td><f:submit handler=action.delete value="Delete Entry" /></td>
> <td><f:submit handler=action.update value="Update Entry" /></td> 
> </tr>
> </f:form>
> [[}]]
>
>
>
>   

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642