Thanks Cliff, I will take a look and let you know how it goes. I did not
think this would need JQuery/Ajax before.
On Thursday, October 24, 2013 4:55:47 PM UTC-4, Cliff Kachinske wrote:
>
> Two chapters in the online manual will answer your questions.
>
> - JQuery and Ajax
> - Components and plugins
>
> I usually go the JQuery/Ajax way, but I think the majority use LOAD to
> load a component.
>
> On Thursday, October 24, 2013 4:24:29 PM UTC-4, Vj wrote:
>>
>> Thanks Dave.
>>
>> Yes, I want to display the categories in the dropdown and based on the
>> selected one, I get all the items from the DB based on the category to
>> display. I did search for it, but I was not able to find anything relevant.
>> Since this is in the same form and initially the results should be empty.
>> After the user selected something, then I need to capture the request
>> variables and use that to query the DB in the same page. I am sure it is
>> possible, but have not seen it in examples(or I might have missed it).
>>
>> If passing the request to the next page altogether is easier, I am open
>> for that too. Thanks again.
>>
>>
>>
>>
>>
>>
>>
>>
>> On Thursday, October 24, 2013 4:10:44 PM UTC-4, Dave S wrote:
>>>
>>> On Thursday, October 24, 2013 12:30:00 PM UTC-7, Vj wrote:
>>>>
>>>> All,
>>>>
>>>> I am trying to have a select (multi select drop down) option in the
>>>> home page and display the results on the home page itself(below the select
>>>> box).
>>>>
>>>> I am able to pull the data from the Table 1 and display in the select
>>>> box. I am not able to use the selected options to query Table 2 and
>>>> display
>>>> the results (though I could display all the data from this table) using
>>>> the
>>>> selected options int he select box. My code is below
>>>>
>>>>
>>> I am not sure what your question is. Do you want the user to select
>>> something from Table 1 (from the select box), and use that to select what
>>> to display from Table 2?
>>>
>>> (If so, I don't know the answer, but some of the topics here about
>>> multiple forms might be relevant.)
>>>
>>> /dps
>>>
>>>
>>>
>>>> default.py
>>>> def index():
>>>> form3 = SQLFORM.factory(Field('select_category',requires=
>>>> IS_IN_DB(db,db.table1.id,'%(category)s',multiple=True)))
>>>> records = db(db.table2.category_id.belongs(1,2)).select() """I
>>>> just tried using 1,2 for testing"""
>>>> return dict(form3=form3,records=records,message=T('Info'))
>>>>
>>>>
>>>>
>>>> index.html
>>>> {{extend 'layout.html'}}
>>>>
>>>> {{=form3}}
>>>> {{=records}}
>>>>
>>>> Here form3 has the select box and the button and once I click the
>>>> button the result set from the table should be displayed as a list. The
>>>> code I have displays all the records from table 2(some of the text is big
>>>> to be displayed). Is there a setting where I can display long text also?
>>>>
>>>> Thanks.
>>>>
>>>>
>>>>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
