Re: Any body here knows the design model of The Oracle of Bacon at Virginia?

John wrote:
> Brian,
>
> Can you do a sql query to find the degrees of separation with your design of
> table?

I would not do this in a simple query. Djikstra's algorithm and the like   are more complex than would normally be formulated in a simple query. I would use SQL to put the data into an array and then use something like a C program to traverse the network.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com