|
| |
|
|
Gax
Posts: 1
Joined: 2/8/2005
Status: offline
 |
a tough "geneological" Query - 2/8/2005 4:13:02
Table = Users
Each record contains a ReferredBy field that tells us who they were referred by.
Bill referred bob, who referred, bill, who referred bubba etc. Some of these can go 20+levels deep.
I want to search by bobs User ID and have it return Bill, Bubba, and everyone else that was a result of his referrals regardless of how many different "generations" it takes.
I have toyed unsuccessfully with some varying methodology. Most of which I really dont like.
Please help.
Gax
|
|
|
|
BeTheBall
Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: a tough "geneological" Query - 2/8/2005 19:48:51
Welcome to OutFront. Where there is nothing in the record that identifies the original referrer, I cannot conceive of a way to do what you propose.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
