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), Child

Re: Nested Menus

2009-10-10 Thread Victor Subervi
in line responses... On Thu, Oct 8, 2009 at 5:58 PM, Dennis Lee Bieber wlfr...@ix.netcom.comwrote: On Thu, 8 Oct 2009 10:38:02 -0500, Victor Subervi victorsube...@gmail.com declaimed the following in gmane.comp.python.general: First suggestion... Get rid of the confusing dat[0] and

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

Re: Nested Menus

2009-10-09 Thread Stephen Hansen
On Fri, Oct 9, 2009 at 7:13 AM, Victor Subervi victorsube...@gmail.comwrote: 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

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

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 = []