But I would have to maintain two identical pieces of code... :-/
On Mon, May 18, 2009 at 8:59 AM, TheDude <officed...@gmail.com> wrote:
>
> Why not define it as you would with any table? If it's already within
> the database, add a migrate=False option :)
>
> On May 18, 7:50 am, Tito Garrido <titogarr...@gmail.com> wrote:
> > Hi Folks! Thank you for yours answers!
> >
> > In fact what a really want is to get db data from a previously defined
> > database on db.py.
> > I have a table there called "album" and I'd like to get those albums to
> > build a menu like on Maximo's example, but getting it from a table
> defined
> > on db.py.
> >
> > Any ideas?
> >
> > Tito
> >
> >
> >
> > On Sun, May 17, 2009 at 11:47 PM, Jason Brower <encomp...@gmail.com>
> wrote:
> >
> > > Shucks, you beat me to it!
> >
> > > On Sun, 2009-05-17 at 19:32 -0700, mdipierro wrote:
> > > > Yes, I think some like this should do it.
> >
> > > > db.define_table('menu_item',
> > > > SQLField('name'),
> > > > SQLField('link'),
> > > > SQLField('position','integer'),
> > > > SQLField('parent','integer',default=0))
> >
> > > > def menu(table=db.menu_item):
> > > > items=table._db(table.id>0).select(orderby=table.parent|
> > > > table.position).as_list()
> > > > parent=0
> > > > p={0:[]}
> > > > for item in items:
> > > > p[item.id]=[]
> > > > p[item.parent].append([item.name,True,item.link,p[item.id]])
> > > > return MENU(p[0])
> >
> > > > {{=menu(db.menu_item)}}
> >
> > > > On May 17, 8:23 pm, Tito Garrido <titogarr...@gmail.com> wrote:
> > > > > Hi...
> >
> > > > > How can I use DB data on menu?
> > > > > I'd like to use db data to build a submenu on menu.py...
> >
> > > > > Thanks!
> >
> > > > > Tito
> >
> > > > > --
> > > > > Linux User #387870
> > > > > .........____
> > > > > .... _/_õ|__|
> > > > > ..º[ .-.___.-._| . . . .
> > > > > .__( o)__( o).:_______
> > > > > Sent from Salvador, BA, Brazil
> >
> > --
> > Linux User #387870
> > .........____
> > .... _/_õ|__|
> > ..º[ .-.___.-._| . . . .
> > .__( o)__( o).:_______
> > Sent from Campinas, SP, Brazil
> >
>
--
Linux User #387870
.........____
.... _/_õ|__|
..º[ .-.___.-._| . . . .
.__( o)__( o).:_______
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
