On Sunday, October 23, 2011 6:47:45 PM UTC-4, noremac wrote:
>
>
>
> On Oct 24, 7:42 am, Christopher Steel <chris...@gmail.com> wrote:
> > Are you looking to generate navigation menu's using table data?
> >
> > If so, you can try a search for web2py "generate menu". Make sure to
> check
> > out the web2pyslices as well, I think one of the very first slices was
> > related to creating dynamic menus.
>
> Thanks for the reply mate but I already have the menu generating from
> the table data. Im looking to make the menu work. It is for an online
> store selling many different products. For example.
>
> Animal
> Dog
> Cat
> Bird
>
> Animal is the main category and dog, cat and bird are subcategories.
>
> When I click on Dog I would like to be able to pass animal and dog as
> parameters to a function of some sort that will generate a query with
> those parameters, something like this.
>
> products = db((db.products.category=='animal') &
> (db.products.subcategory=='dog')).select(db.products.all)
>
def products():
products = db((db.products.category==request.args(0)) &
(db.products.subcategory==request.args(1)).select()
return dict(products=products)
Then construct your menu so the links include the category and subcategory
as arguments. For dogs, the link should be:
URL('your_controller', 'products', args=['animal', 'dog'])
Which will generate the URL /your_app/your_controller/products/animal/dog.
Anthony
