Friends of Nepal - New Jersey
Discussion Forum
SELECT * from EmailUsers
WHERE Thread_ID = #form.Thread_ID#
AND ThreadUserEmail = '#form.ThreadUserEmail#'
INSERT INTO EmailUsers
(ThreadUserName, ThreadUserEmail, Thread_ID)
VALUES
('#form.ThreadUserName#', '#form.ThreadUserEMail#', #form.Thread_ID#)
Insert Into Messages
(Thread_ID, Parent_Message_ID, Reply_ID, ThreadUserName, ThreadUserEmail, EmailMe, Subject, Posted, Body)
Values
('#Thread_ID#', '#Parent_Message_ID#', '#Reply_ID#', '#ThreadUserName#', '#ThreadUserEmail#', '#EmailMe#', '#Subject#', #Posted#, '#form.body#')
SELECT Threads.Thread_ID, Threads.Name,
Count(Messages.Message_ID) AS MessageCount,
Max(Messages.Posted) As LastMessage
FROM Messages Messages, Threads Threads
WHERE Threads.Thread_ID = Messages.Thread_ID
AND Threads.Name Like '%#Title#%'
GROUP BY Threads.Thread_ID, Threads.Name
HAVING Max(Messages.Posted) > (#Now()#-#Age#)
ORDER BY Max(Messages.Posted) DESC