Nead a guru in to-many relations

Ricardo Strausz <[email protected]> Wed, 30 Jul 2003 15:39:35 -0500
Newsgroups gmane.comp.web.webobjects.eof
Message-ID <[email protected]>
Hola tod@s!

I have the following problem/chalenge:

I wanto neast data into neasted data. That is, I want to write a 
generic method(s) which alow me to do something like

docs<->>docs<->>docs<->>...<->>docs

For example,

The class Docs (represented in an enity TDocs) has a to-many relation 
with its Details (which are type of Docs); each detail may have a 
to-many relation to its Products (which again are type of Docs). Until 
here, I have no problem (well not too much): I can have 3 concrete 
subclasses of Docs represented with 3 different entities, say TDocs, 
TDetails and TProds, and use 1 key for Docs, 2 keys for Details and 3 
keys for Prods (so I can search for the third product of the second 
item in the last document, with a direct fetch in TProds).

But a Product may be made of Products so I nead a to-many relation 
TProds<-->>TProds which may be neasted over and over...

With this panorama, I decided to forget about the 3 first levels and 
try to solve this in a more generic perspective, not yet with a 
satisfactory answer...

How can I neast objects of the same kind over and over??
Is there a usefull db/sql/eof mechanism to perform this??

Any idea will be VERY wellcome.

Gracias,


Dino
http://homepage.mac.com/strausz