Re: SQL, related records (quotes)
From: Stefan Rybacki <stefan.rybacki_at_gmx.net>
Date: Fri, 24 Jun 2005 23:25:27 +0200
Message-ID: <3i3c28F18sluU1_at_individual.net>
>> timpea_at_gmail.com wrote:
>>
>>> Hi,
>>>
>>> I have a website that users can request quotes, and a user may also
>>> make a new quote that links to a previous quote.
>>>
>>> QuoteNo PreviousQuoteNo
>>> 1
>>> 2
>>> 3 1
>>> 4 3
>>> 5 4
>>>
>>> If i request quoteNo 3 i want to have a list of all the related quotes.
>>>
>>>
>>> RelQuote
>>> 1
>>> 3
>>> 4
>>> 5
>>>
>>> Is this possible with a SQL statement? or would i be best doing a loop
>>> in asp and many requests?
>>> Thanks Tim Pearson
>>>
>>
>> Try the nested sets model.
Date: Fri, 24 Jun 2005 23:25:27 +0200
Message-ID: <3i3c28F18sluU1_at_individual.net>
Jan Hidders wrote:
> Stefan Rybacki wrote: >
>> timpea_at_gmail.com wrote:
>>
>>> Hi,
>>>
>>> I have a website that users can request quotes, and a user may also
>>> make a new quote that links to a previous quote.
>>>
>>> QuoteNo PreviousQuoteNo
>>> 1
>>> 2
>>> 3 1
>>> 4 3
>>> 5 4
>>>
>>> If i request quoteNo 3 i want to have a list of all the related quotes.
>>>
>>>
>>> RelQuote
>>> 1
>>> 3
>>> 4
>>> 5
>>>
>>> Is this possible with a SQL statement? or would i be best doing a loop
>>> in asp and many requests?
>>> Thanks Tim Pearson
>>>
>>
>> Try the nested sets model.
> > > Are you sure the relation describes always a tree?
Yes. Since you could write for a better understanding QuoteNo as NodeID and PreviousQuoteNo as ParentID. So each Node points to its parent node.
Regards
Stefan
>
> -- Jan Hidders
Received on Fri Jun 24 2005 - 23:25:27 CEST