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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
