I made a change in trunk that will also allow you to do this in less
lines:
Controller:
def kit():
table=db.kit
items=db().select(table.ALL) ### list is a keyword in python
return dict(items=items,table=table)
and in view
{{for item in items:}}
<button onclick="$('#h{{=item.id}}').slideToggle()">{{=item.id}}</
button>
<div id="h{{=item.id}}" class="h">{{=crud.update
(table,item.id,next='index')}}</div>
{{pass}}
<script>$(document).ready(function(){$('.h').hide()});</script>
Massimo
On Apr 17, 4:03 pm, mdipierro <[email protected]> wrote:
> My suggestion is do not use crud.select(). Do something like
>
> Controller:
> def kit():
> table=db.kit
> items=db().select(table.ALL) ### list is a keyword in python
> return dict(items=items,table=table)
>
> and in view
>
> {{for item in items:}}
> <button onclick="$('#h{{=item.id}}').slideToggle()">{{=item.id}}</
> button>
> <div id="h{{=item.id}}" class="h">
> {{form=SQLFORM(table,item.id,formname=item.id)}}{{=form}}
> {{if form.accepts(request.vars,session): redirect(URL(r=request))}}
> </div>
> {{pass}}
> <script>$(document).ready(function(){$('.h').hide()});</script>
>
> Massimo
>
> On Apr 17, 3:23 pm, Fran <[email protected]> wrote:
>
> > I am using crud.select() to show a nice SQLTABLE list of the items in
> > a kit.
> > What I'd like to be able to do is to amend the quantity of items
> > directly within this table, but my attempts so far are failing because
> > I can't pass the row into the .represent.
>
> > Simplified model:
> > db.define_table('kit',db.Field('item_id'),db.Field('quantity'))
>
> > Controller:
> > def kit():
> > table=db.kit
> > table.quantity.represent=lambda qty: INPUT
> > (value=qty,requires=IS_NOT_EMPTY())
> > list=crud.select(table)
> > return dict(list=list)
>
> > I want to be able to do something like:
> > table.quantity.represent=lambda qty,record: INPUT
> > (value=qty,_name=record,requires=IS_NOT_EMPTY())
>
> > table.quantity.represent=lambda qty: SQLFORM(table,record,fields=
> > ['quantity'],showid=False)
> > table.quantity.represent=lambda qty: FORM(INPUT
> > (value=qty,_name=record,requires=IS_NOT_EMPTY()))
>
> > If I can't do form-fields directly inside the table then at least
> > links would be good, but this has the same problem:
> > table.quantity.represent=lambda qty: A(qty,_href=URL
> > (r=request,f='kit_quantity',args=[record,qty]))
>
> > How can I pass the record into the lambda?
> > - or do something which achieves the same thing...
>
> > Many thanks,
> > Fran.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
