On 30 sep, 17:41, MichaelT <[email protected]> wrote:
> Hi,
>
> ** I think I made a mistake and first created a topic instead of a
> post. Rookie mistake, Sorry for dupe. ***
>
> I'm trying to understand what I have to do and what can be done
> automatically with FORM (not SQLFORM).
>
> I want to create a form that is the same functionally as SQLFORM,
> meaning the fields from related tables are populated as drop down
> buttons, etc. But I don't want to use SQLFORM.
>
> Can FORM populate the drop down list or do I need to select the
> records to a record object and then use that object ?
>
> Can someone point me to a complete example?
>
> Thanks very much.
> Michael

Hi,

def myform():
    rows = db().select(db.mytable.ALL, orderby=db.mytable.myfield,
cache=(cache.ram,3600))

    sel_rows = SELECT(_name='id_1', _id='id_1',
            *[OPTION(rows[i].myfield, _value=rows[i].id) for i in range
(len(rows))])


    form = FORM(TABLE(
            TR("A Label:", sel_rows),
            TR("", INPUT(_type="submit")
            )

    return dict(form=form)

Jose
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py-users" 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to