e :)
Norman
-Original Message-
From: Cody [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 11:26 AM
To: CF-Talk
Subject: RE: Database Design Help
I tried setting it up using the tutorial on secretagents.com (based on
Celko's Nested Set model), everything seemed to be going alon
" <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 8:01 AM
Subject: RE: Database Design Help
> I built a site very similar to this, using the technique Bill explained,
> with each record having a "parent" record. If you KNOW for sure that there
> will be no more th
parent, then again to find the parent's parent. At least that was
>the only way I figured out :).
>
>Norman Elton
>
>-----Original Message-
>From: Bill King [mailto:[EMAIL PROTECTED]]
>Sent: Monday, June 11, 2001 11:41 AM
>To: CF-Talk
>Subject: Re: Database Design H
nt's parent. At least that was
the only way I figured out :).
Norman Elton
-Original Message-
From: Bill King [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 11:41 AM
To: CF-Talk
Subject: Re: Database Design Help
Cody,
I think you should still design the system so that it can
My first thought is to use a self-referencing table.
Page (PageID, categoryinfo, ParentID)
ParentID references back to PageID. Set it to zero for top-level
categories.
You can get any page by selecting where pageID = currentpageID
You can get all children by selecting where pare
hen query all items with the same parent.
You can reply to me directly if I have confused you with this.
- BILL -
- Original Message -
From: "Cody" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 7:23 AM
Subject: Database De
tat complex. The advantage of
this is that you are not restricted to 3 levels should you wish to expand.
where you have
-Original Message-
From: Cody [mailto:[EMAIL PROTECTED]]
Sent: 11 June 2001 15:23
To: CF-Talk
Subject: Database Design Help
Hello. I'm trying to build an applic
Hello. I'm trying to build an application but I'm stuck on designing the DB. I'll try
to explain how the site is going to be made, and hopefully someone can help.
There are only going to be 3 levels of pages. Category pages, sub pages, and sub-sub
pages. I want to be able to call any page, w
8 matches
Mail list logo