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