records=SQLTABLE
<http://127.0.0.1:8000/examples/global/vars/SQLTABLE>(db(db.Cricket.Name ==
form.vars.Name).select(db.Cricket.ALL))
On Friday, 26 May 2017 08:36:29 UTC-5, Swayambodha Mohapatra wrote:
>
> I am a novie in coding. Please help me out.
> How to create a drop down form that shows the user the data specific to a
> record?
> For example, in this code I have the data stored for a number of cricket
> players. In this drop down list, I want to just show the data specific to
> the player chosen from the drop down menu.
>
> db.define_table ('Cricket',
> Field
> <http://127.0.0.1:8000/examples/global/vars/Field>('Name'),
> Field
> <http://127.0.0.1:8000/examples/global/vars/Field>('Age'),
> Field
> <http://127.0.0.1:8000/examples/global/vars/Field>('ODI_Runs'),
> Field
> <http://127.0.0.1:8000/examples/global/vars/Field>('ODI_Wickets')
> )
> db.Cricket.Name.requires = IS_NOT_EMPTY
> <http://127.0.0.1:8000/examples/global/vars/IS_NOT_EMPTY> ()
> db.Cricket.Age.requires = IS_INT_IN_RANGE
> <http://127.0.0.1:8000/examples/global/vars/IS_INT_IN_RANGE> (0,100)
> db.Cricket.ODI_Runs.requires = IS_INT_IN_RANGE
> <http://127.0.0.1:8000/examples/global/vars/IS_INT_IN_RANGE> (0,20000)
> db.Cricket.ODI_Wickets.requires = IS_INT_IN_RANGE
> <http://127.0.0.1:8000/examples/global/vars/IS_INT_IN_RANGE> (0,1000)
>
> def index(): return dict(message="hello from view_data.py")
> def view_data() :
> form=SQLFORM
> <http://127.0.0.1:8000/examples/global/vars/SQLFORM>.factory(Field
> <http://127.0.0.1:8000/examples/global/vars/Field>('Name',requires=IS_IN_DB
> <http://127.0.0.1:8000/examples/global/vars/IS_IN_DB>(db,'Cricket.Name')))
> if form.accepted:
> response
> <http://127.0.0.1:8000/examples/global/vars/response>.flash='Viewing Selected
> Data'
> records=SQLTABLE
> <http://127.0.0.1:8000/examples/global/vars/SQLTABLE>(db().select(db.Cricket.ALL))
> // This is the part where the problem lies. I don't know how to pass the
> 'Name' that has been selected.
> return dict(form=form, record=records)
> response <http://127.0.0.1:8000/examples/global/vars/response>.menu=[['View
> Player Data', False, URL
> <http://127.0.0.1:8000/examples/global/vars/URL>(view_data)]]
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
