Thank you, I have something working here for a threaded message forum but it
does it's dirty work in cf and not in the database
----- Original Message -----
From: "Dan G. Switzer, II" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 19, 2000 3:54 PM
Subject: RE: Parent/Child query
> 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.
------------------------------------------------------------------------------
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.
