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
--
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.
