Ok, what actualy do you wanna do? Sort records by dependencies, then
other records(that don't have them) sort in other order(alphabeticaly
or in order of appearance in the table)? if it is so you can do
this:
SELECT fieldName FROM table ORDER BY dependatOn,fieldName(or id - an auto_increment
fiel
> Yes, the concepts he presents are in generic SQL. I've used them in 2
> different systems (menus and security) and they work fine. (NOTE: You DO
> have to write your own code.) ;)
Ok, I picked up the book yesterday. It has alot of really good information.
However, with regards to the concept
From: Chris Boget [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 03, 2002 3:20 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Record dependencies
> SQL for Smarties by the demigod Joe Celko. Chapters 28 and 29 describe
this
> tree structure. READ BOTH OF THEM, even though you wo
> SQL for Smarties by the demigod Joe Celko. Chapters 28 and 29 describe this
> tree structure. READ BOTH OF THEM, even though you won't use the code in
> 28. Chap 29 holds the simplified concepts to make a tree structure work with
> single select.
> It's not easy. It's a complex concept but onc
http://www.amazon.com/exec/obidos/ASIN/1558605762/qid=1023135114/sr=8-1/ref=
sr_8_1/104-1283502-0494342
SQL for Smarties by the demigod Joe Celko. Chapters 28 and 29 describe this
tree structure. READ BOTH OF THEM, even though you won't use the code in
28. Chap 29 holds the simplified concepts
