SELECT ID, TopicID, ReplyIDs, NumReplies, TSCreated, Title, Author, Username, Email, Body FROM Threads WHERE (TopicID = #attributes.TopicID# OR ID = #attributes.TopicID#) AND Deleted =0 ORDER BY ID topic_thread[GetTopicThreads.ID] = StructNew(); topic_thread[GetTopicThreads.ID].ReplyIDs = GetTopicThreads.ReplyIDs; topic_thread[GetTopicThreads.ID].NumReplies = GetTopicThreads.NumReplies; topic_thread[GetTopicThreads.ID].Title = GetTopicThreads.Title; topic_thread[GetTopicThreads.ID].Author = GetTopicThreads.Author; topic_thread[GetTopicThreads.ID].TSCreated = GetTopicThreads.TSCreated; topic_thread[GetTopicThreads.ID].Username = GetTopicThreads.Username; topic_thread[GetTopicThreads.ID].Email = GetTopicThreads.Email; topic_thread[GetTopicThreads.ID].Body = GetTopicThreads.Body; Select USERNAME, EMAIL, #biosketch_field# from Users where ID > 100 order by USERNAME; // show/hide thread table? // NO LONGER USED, the rest of the code needs the printed_ID_list which is created during the printing of this table if(attributes.ShowThreadTable){ show_dsp = "[ #HeaderFont#hide ]"; } else { show_dsp = "[ #HeaderFont#show ]"; }

if (ListLen(topic_thread[attributes.TopicID].ReplyIDs) GT 0) { replies_dsp = " (#ListLen(topic_thread[attributes.TopicID].ReplyIDs)#)"; } else { replies_dsp = ""; } printed_ID_list = "#attributes.TopicID#,"; row_num = 1; indent_level = 1; // setup arrays for "_act_topic_threads.cfm" recursion this_ReplyIDs = ArrayNew(1); this_NumReplies = ArrayNew(1); this_ID = ArrayNew(1); this_Title = ArrayNew(1); this_Author = ArrayNew(1); this_TSCreated = ArrayNew(1); this_ReplyIDs[indent_level + 1] = topic_thread[attributes.TopicID].ReplyIDs; #HeaderFont#  #ThreadLabelPlural# For This #TopicLabel# #HeaderFont#  Posted by   #HeaderFont#  Date  #RowHeight_img# #DefaultFont#  #topic_thread[attributes.TopicID].Title##replies_dsp#   #DefaultFont#  #topic_thread[attributes.TopicID].Author#   #DefaultFont#  #DateFormat(topic_thread[attributes.TopicID].TSCreated,'mmm d, yyyy')#  #RowHeight_img#

// what row color? if (row_num MOD 2 eq 1) {bg_color=RowColor2;} else {bg_color=RowColor1;} row_num = row_num + 1; if (topic_thread[this_ID].USERNAME NEQ "-") { // Biosketch link? if (biosketch_links[topic_thread[this_ID].USERNAME] EQ "-") { this_Author = topic_thread[this_ID].Author; } else { this_Author = "#topic_thread[this_ID].Author#"; } // update this_Email from member database topic_thread[this_ID].Email = email_address[topic_thread[this_ID].USERNAME]; }

#DefaultFont#		#DefaultFont#
	#DefaultFont##topic_thread[this_ID].Title# #this_Author# #this_Author# <#topic_thread[this_ID].Email#> #DateFormat(topic_thread[this_ID].TSCreated,'mmm d, yyyy')# #replace(topic_thread[this_ID].Body, "#Chr(9)#", "#TabConvertsTo#", "ALL")# Reply | Top	#DefaultFont#