On Thursday, February 8, 2018 at 9:55:25 AM UTC-8, Matthew J Watts wrote: > > Hi community > > I'm having a few problems trying to understand how create a cascading drop > down list. I've followed this recipe - > > > http://www.web2pyslices.com/slice/show/1526/cascading-drop-down-lists-with-ajax-2 > > i've managed to adapt it slightly, but i'm having trouble trying to add > more tables to the cascade/sequence >
I'm not much of a menu person (I make use of ordinary anchor links for the most part), but that example was probably written when BootStrap2 was the css/javascript in use. Currently, web2py ships with BootStrap3, which doesn't support more than 1 level of submenus. If you use stupid.css (as in applications/example), you might not have that limitation, but I can't show you what you want. > It is quite difficult for me (a beginner) to suss out the logic behind it > > Menus typically control what is shown by using javascript to manipulate CSS. Simple menus may be CSS only, but then they'd be statically defined. Good luck! /dps > So at the moment i have the code below, what i'm trying to do is return a > list of values from the "tax_class" table, based on a selection from > the "tax_phylum" table( based on sececting an entry from the kingdom > table) > > *model* > > db.define_table('tax_kingdom', > Field('name')) > > db.define_table('tax_phylum', > Field('name', 'string'), > Field('kingdom_id')) > db.tax_phylum.kingdom_id.requires = IS_IN_DB(db, db.tax_kingdom.id, > '%(name)s') > > db.define_table('tax_class', > Field('name', 'string'), > Field('phylum_id')) > db.tax_class.phylum_id.requires = IS_IN_DB(db, db.tax_phylum.id, '%(name)s') > > > *Controller* > > def index(): > kingdoms = db().select(db.tax_kingdom.ALL) > > if request.vars.kingdom_name: > phylum_select = db(db.tax_phylum.id == > request.vars.kingdom_name).select(db.tax_phylum.ALL) > else: > phylum_select = db(db.tax_phylum.id == 1).select(db.tax_phylum.ALL) > return dict(kingdoms=kingdoms, phylum_select=phylum_select) > > > def phylum(): > phylums = db(db.tax_phylum.kingdom_id == > request.vars.kingdom_name).select(db.tax_phylum.ALL) > result = "" > for p in phylums: > result += "<option value='" + str(p.id) + "'>" + p.name + "</option>" > return XML(result) > > > > *view* > > > > {{extend 'layout.html'}} > > <form enctype="multipart/form-data" action="{{URL()}}" method="post"> > <select name='kingdom_name' > onchange="jQuery('#kingdom_name').empty(); > ajax('phylum', ['kingdom_name'], 'phylum_name');"> > {{for kingdom in kingdoms:}} > <option value="{{=kingdom.id}}" > {{=" selected='selected'" if > str(kingdom.id)==request.vars.kingdom_name else ""}}> > {{=kingdom.name}} > </option> > {{pass}} > </select> > > > <select id='phylum_name' name='phylum_name' > > <!-- loop through the index function i --> > {{for phylum in phylum_select:}} > <option value="{{=phylum.id}}" > {{=XML(" selected='selected'") if > str(phylum.id)==request.vars.phylum_name else ""}}> > {{=phylum.name}}</option> > {{pass}} > </select> > > > </form> > > -- 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/d/optout.