Re: Nested Menus

2009-10-13 Thread Victor Subervi
This is probably more appropriate for the MySQL list, but since this is Dennis' pseudo-code... Dennis wrote the following: cursor.execute("""create table if not exists Relationship (ID integer auto_increment primary key, Parent integer not null, foreign key (Categories.ID), Chi

Re: Nested Menus

2009-10-10 Thread Victor Subervi
in line responses... On Thu, Oct 8, 2009 at 5:58 PM, Dennis Lee Bieber wrote: > On Thu, 8 Oct 2009 10:38:02 -0500, Victor Subervi > declaimed the following in > gmane.comp.python.general: > >First suggestion... Get rid of the confusing dat[0] and dat[1] and > use names that make sense...

Re: Nested Menus

2009-10-09 Thread Victor Subervi
Well, as sometimes happens, the response to Dennis' response caught my attention (out of context) and I didn't notice Dennis' response! Thanks for bringing it to my attention. I will look at it tonight, and follow-up tomorrow after I've had a chance to digest it and work with it. (And thank you Den

Re: Nested Menus

2009-10-09 Thread Stephen Hansen
On Fri, Oct 9, 2009 at 7:13 AM, Victor Subervi wrote: > Hmm. I didn't bother to look at the "comparison post". The indenting looks > right to me. I reread my post and I believe my question is straight-forward. > The crux of the issue is my sentence at the bottom. I believe that details > what my o

Re: Nested Menus

2009-10-09 Thread Victor Subervi
Hmm. I didn't bother to look at the "comparison post". The indenting looks right to me. I reread my post and I believe my question is straight-forward. The crux of the issue is my sentence at the bottom. I believe that details what my objective is. Not sure what I should do here. I hope you can cla

Nested Menus

2009-10-08 Thread Victor Subervi
Hi; I have the following code: sql = 'create table if not exists categories (ID int(3) unsigned primary key, Category varchar(40), Parent varchar(40))' cursor.execute(sql) cursor.execute('select Category, Parent from categories;') data = cursor.fetchall() parents = [] Parents = [] for