Seems allaire's forums are able to do something real similar. Isnt their
app [Forums] now Open Sourced? Would their queries provide the needed
clues?
Just a quick, not well researched thought.
Steve
----- Original Message -----
From: "Nick Slay" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, January 21, 2001 2:59 PM
Subject: Help with grouping
> Ok, I'm beating my head trying to figure this one out, so I figured I'd
try
> the list to see if anyone can help out before I tear ALL my hair out!!!
>
> I'm currently writing a Forum System, and I just can't figure out a way of
> grouping the messages correctly...
>
> If I have 10 messages entered, I want them to come out like this....
>
> 1. this is a test
> 3. re: this is a test
> 4. re: this is a test
> 6. re: re: this is a test
> 7. re: this is a test
>
> 2. second message
> 5. re: second message
> 8. re: second message
> 10 re: re:second message
> 9. re: second message
>
>
> This is how I'd like the display to look, with the messages being entered
> into the system in the order of the numbers.
>
> Can anyone offer any suggestions as to how I can structure a query to pull
> these records out in the correct order. I have tried ideas like using
> grouping and sorts on the parent Id, and dates. I guess I need to add
some
> sort of field to take care of the sorting, but I'm a bit lost as to what
to
> use here!!
>
> Thanks in advance for any suggestions.
>
> Nick
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists