PS - Make sure to get the 2nd Edition version of Joe Celko's SQL for
Smarties. According to the liner notes, there are big differences between
the two versions. Apparently 1st Edition doesn't cover hierarchical trees to
the depth that 2nd Edition does.
-Dan
-----Original Message-----
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 9:35 AM
To: [EMAIL PROTECTED]
Subject: RE: Parent/Child query
Dirk,
I'll try to write an article up describing the basic concept next week. I'll
post in on the OACFUG site (http://www.oacfug.org/.) I'd recommend for
anyone looking to do parent/child relationships in a database, to buy the
SQL for Smarties book by Joe Celko. It's not a beginners book by any means,
but has some really great useful tips for organize your data.
-Dan
+--------+---------------------------+
| name | Dan G. Switzer, II |
|company | PengoWorks.com |
| www | http://www.pengoworks.com |
| mailto | [EMAIL PROTECTED] |
+--------+---------------------------+
-----Original Message-----
From: Dirk De Bock [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 9:21 AM
To: [EMAIL PROTECTED]
Subject: Re: Parent/Child query
I think a lot of people could use something like this so do please consider
setting up a web page with explanations and source code or some such.
----- Original Message -----
From: "Dan G. Switzer, II" <[EMAIL PROTECTED]>
> I have a working model of the "nested set tree" in a working Access
> database. Let me know if you want a copy of it. It works a little
different
> then the standard adjacent list (aka, the parent/child relation) but it
> seems to work really will. The concept is based off of something in the
book
> "SQL for Smarties"-which is a great book.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
