Search in NestedSets
Date: 12 May 2005 05:33:00 -0700
Message-ID: <1115901180.234253.183170_at_g14g2000cwa.googlegroups.com>
hello everyone...
i hope i am right here with my problem. this is what driving me nuts since a long time:
i have 3 tables, one for adresses, one for a structure and one for referencing both together. the structure table is a nested sets table. everything is fine, reading, checking the tree, insert etc.
so now i want to search in the adresses for a specific one. let's say i make a search LIKE '%Schmit%' or whatever. i need help how i can get the adress, the structure element that it is in AND the whole tree above this element with ONE query. it's driving me nuts. i can't figure it out.
by the way the only information that i am storing in the reference table is the id of the adress and the id of the structure element that it is in. and sure each entry in this table has also a id.
thanks a lot for your help. Received on Thu May 12 2005 - 14:33:00 CEST