Thanks Alan
On Fri, Mar 30, 2012 at 6:11 PM, Alan Etkin <[email protected]> wrote:
> There may be javascript issues:
>
>
> > onchange="ajax('admin_assign',['org_name'],'shadow_clone');"
>
> Wouldn't the 'shadow_clone' be specified as '#shadow_clone'? (as it is an
> element selected by id)
>
> > onchange="jQuery(maker_name).remove(); ...
>
> Does the maker_name js variable exist? if maker_name is an element's name
> I'd use this instead:
>
> jQuery('[name=maker_name]').remove();
>
>
> On Friday, March 30, 2012 1:54:48 AM UTC-3, Sanjeet Kumar wrote:
>>
>> Yes my code is from web2py slices
>>
>> I have the following view :-
>>
>> {{left_sidebar_enabled,right_**sidebar_enabled=True,False}}
>> {{extend 'adminlayout.html'}}
>> <div id="contdoc">
>> <h4>Themis Project Console</h4>
>> </div>
>> <div id="contdoc">
>>
>> <form name="assign" action="{{=URL('default','**
>> admin_submit_assign_project')}**}" method="post" onsubmit="return
>> showcnf()" >
>>
>> Select Organization : <select name='org_name'
>> onchange="ajax('admin_assign',**['org_name'],'shadow_clone');"**>
>> {{for org in organization:}}
>> <option value="{{=org.organization}}" >
>> {{=org.organization}}
>> </option>
>> {{pass}}
>> </select>
>>
>> </br>
>>
>> Select Department : <select name='category_name'
>> onchange="jQuery(maker_name).**remove();
>> ajax('admin_assign_pro', ['category_name'], 'shadow_clone');">
>> {{for category in categories:}}
>> <option value="{{=category.category}}"**
>> {{=" selected='selected'" if
>> str(category.category)==**request.vars.category_name
>> else ""}}>
>> {{=category.category}}
>> </option>
>> {{pass}}
>> </select>
>>
>> <span id='shadow_clone'></span>
>>
>> </br>
>>
>> Select Employee Email : <select name='maker_name'>
>> {{for maker in makers:}}
>> <option value="{{=maker.email}}"
>> {{=XML(" selected='selected'") if
>> str(maker.email)==request.**vars.maker_name else ""}}>
>> {{=maker.email}}
>> </option>
>> {{pass}}
>> </select>
>> </br>
>> <input type="submit" value="Submit" />
>> </form>
>>
>> <hr>
>>
>> </div>
>>
>> <div id="contdoc">
>> {{=form}}
>> </div>
>>
>> and the following Controller :-
>>
>>
>> def admin_assign_project():
>> for row2 in db(db.image.email == auth.user.email).select():
>> images=row2.image
>> db.assign_project.id.readable=**False
>> form=SQLFORM.grid(db.assign_**project)
>> projects=db().select(db.admin_**add_project.ALL)
>> organization=db().select(db.**auth_user.ALL)
>> categories = db().select(db.category.ALL)
>> if request.vars.org_name:
>> makers = db(db.auth_user.organization==**request.vars.org_name).select(**
>> db.auth_user.ALL)
>> else:
>> makers = db(db.auth_user.organization==**'').select(db.auth_user.ALL)
>> return dict(organization=**organization,categories=**categories,
>> makers=makers, images=images, form=form)
>>
>> def admin_assign():
>> makers = db((db.auth_user.organization=**=request.vars.org_name)).**
>> select(db.auth_user.ALL)
>> result = "<select name='maker_name'>"
>> for maker in makers:
>> result += "<option value='" + str(maker.category) + "'>" +
>> str(maker.category) + "</option>"
>> result += "</select>"
>> return XML(result)
>>
>>
>> def admin_assign_pro():
>> makers = db((db.auth_user.department==**request.vars.category_name)).
>> **select(db.auth_user.ALL)
>> result = "<select name='maker_name'>"
>> for maker in makers:
>> result += "<option value='" + str(maker.email) + "'>" +
>> str(maker.email+'\t'+'('+**maker.first_name+'\t'+maker.**last_name+')')
>> + "</option>"
>> result += "</select>"
>> return XML(result)
>>
>>
>> Here I want to value in second drop-down category_name filtered on the
>> first drop-down org_name which are selected and the value in the third
>> drop-down maker_name filtered on the second drop-down which will be
>> selected via ajax.
>>
>> I am getting the value only in the second drop-down but i am not be able
>> to get the value in the third drop-down filtered on the second . Thanks in
>> advance .
>>
>