db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Noll <dan...@nuix.com.au>
Subject Re: Recursive Select for Discussion Forum
Date Wed, 30 Nov 2005 05:32:41 GMT
Michael McCutcheon wrote:

> <snip>
> If not, are there any ways of handling scenarios like this without 
> having to do a select for each item?

I would have done this by having a discussion_id / thread_id column.

A discussion generally has properties of its own, so in a full 
application you would presumably have a discussion or thread table 
already.  Selecting all messages in that discussion then becomes a 
trivial matter.


Daniel Noll

NUIX Pty Ltd
Level 8, 143 York Street, Sydney 2000
Phone: (02) 9283 9010
Fax:   (02) 9283 9020

This message is intended only for the named recipient. If you are not
the intended recipient you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
message or attachment is strictly prohibited.

View raw message