Anthony, here's more info.
In my form, you need to choose a department to generate respective list of
ranks. The tables involved:
db.define_table('department',
Field('name', length = 30),
format=lambda r: r.name
)
db.define_table('rank',
Field('department_id', db.department),
Field('name', length = 50),
format=lambda r: r.name
)
I reference the tables in my user profile table (user has i.a. department
and rank).
When user wants to insert data, the view generates a custom crud form
(below) -- nothing fancy here. However, I need to modify the piece of code
which deals with *rank *- to auto-populate it based on department chosen:
{{=form.custom.begin}}
{{=form.custom.widget.department}}
{{=form.custom.widget.rank.label}}
<div class="w2p_fw">
{{if request.vars.department:}}
<select class="generic-widget" id="seafarer_experience_rank"
name="rank">
{{=XML(result)}}
</select>
{{else:}}
{{=add_experience.custom.widget.rank}}
{{pass}}
</div>
....
{{=form.custom.end}}
So, when user displays the form, the *department *variable is not set
(True) yet. In that case all ranks are being displayed in the select_2
(else: ...). Then, when user chooses an option from select_1 (department),
jQuery change() triggers and ajax() sends department variable to *populate
*function.
The variable is used in the query (my first post) to retrieve ranks
connected with the departmet chosen, and send it back to the view as
<option></option> tags -- {{=XML(result)}}.
As I said - it works for inserting data. Does not when I try to update.
I use the same HTML + web2py code as in the form code above for both insert
and update forms.
I'm still being not clear enough, let me know. And thanks.
On Saturday, June 22, 2013 8:04:39 PM UTC+2, Anthony wrote:
>
> Sorry, it wasn't clear that it was failing upon change of select_1. It
> might help to show more of the code that creates and displays the form, as
> it is not quite clear how everything is working. In particular, I don't
> quite get what that view code is doing and where it is used.
>
> Anthony
>
> On Saturday, June 22, 2013 1:55:18 PM UTC-4, lesssugar wrote:
>>
>> Yes, of course you're right, I guess I wasn't clear enough. The real
>> problem is this: what if a user needs to change the value of select_1 in
>> order to update their data? Then, depending on what they choose, select_2
>> should still be auto-populated.
>>
>> I don't get why code which works for insert form fails when it comes to
>> update. Can it be connected to the fact that the update form shows specific
>> value of select_1? Not sure. But jquery change() should anyway spot the
>> select change action and trigger ajax().
>>
>> On Saturday, June 22, 2013 7:39:05 PM UTC+2, Anthony wrote:
>>>
>>> $('#select_1').change(function()
>>>
>>> You're using a "change" event handler, so it will only fire when the
>>> value of select_1 is changed. When the update form is first loaded, the
>>> existing record's value for select_1 is shown, but there is no change event
>>> to trigger the retrieval of the select_2 values.
>>>
>>> Note, for an update form, it should be possible to populate select_2 on
>>> the server rather than via ajax, since you already have the value of
>>> select_1.
>>>
>>> Anthony
>>>
>>> On Saturday, June 22, 2013 1:29:02 PM UTC-4, lesssugar wrote:
>>>>
>>>> I have 2 select boxes. I managed to auto-populate second select box
>>>> based on value from the first one. All of the code below works just fine
>>>> when I create new record - second select is being populated. However, when
>>>> I try to update the same record, select_2 does not get populated, as if
>>>> the
>>>> *department* variable never reached the *populate* function. As a
>>>> result, there's a view rendered within select_2 instead of
>>>> <option></option> elements. This occurs only in the update form.
>>>>
>>>> The script passing *department *variable from select_1:
>>>>
>>>> <script>
>>>> $('#select_1').change(function() {
>>>> ajax('populate', ['department'], 'select_2');
>>>> });
>>>> </script>
>>>>
>>>> *populate *function which uses "department" var to get respective data:
>>>>
>>>> def populate():
>>>>
>>>> ranks = db(db.rank.department_id == request.vars.department).select(
>>>> db.rank.id, db.rank.name, orderby=db.rank.name)
>>>>
>>>> result = ""
>>>>
>>>> for r in ranks:
>>>> result += "<option value='" + str(r.id) + "'>" + r.name +
>>>> "</option>"
>>>>
>>>> return XML(result)
>>>>
>>>> view:
>>>>
>>>> <div class="w2p_fw">
>>>> {{if request.vars.department:}}
>>>> <select class="generic-widget" id="seafarer_experience_rank"
>>>> name="rank">
>>>> {{=XML(result)}}
>>>> </select>
>>>> {{else:}}
>>>> {{=form.custom.widget.rank}}
>>>> {{pass}}
>>>> </div>
>>>>
>>>>
>>>>
--
---
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/groups/opt_out.
