SELECT u.userID,u.firstName,u.lastName,u.avatar,m.messageID,m.categoryID,m.milestoneID,m.title,m.message, m.allowcomments,m.stamp,ms.name,mc.category, (SELECT count(commentID) FROM #variables.tableprefix#comments c where m.messageid = c.itemid and type = 'msg') as commentcount, (SELECT count(fileID) FROM #variables.tableprefix#file_attach fa where m.messageid = fa.itemid and fa.type = 'msg') as attachcount FROM #variables.tableprefix#messages m LEFT JOIN #variables.tableprefix#categories mc ON m.categoryID = mc.categoryID LEFT JOIN #variables.tableprefix#users u ON u.userID = m.userID LEFT JOIN #variables.tableprefix#milestones ms ON m.milestoneid = ms.milestoneid WHERE m.projectID = AND m.messageID = AND m.categoryID = AND m.milestoneID = AND m.stamp between #createdate(arguments.y,arguments.m,'1')# AND #createDateTime(arguments.y,arguments.m,daysInMonth(createdate(arguments.y,arguments.m,'1')),'23','59','59')# AND mc.type = 'msg' ORDER BY m.stamp desc SELECT u.userID,u.firstName,u.lastName,u.email,u.mobile, u.email_files, u.mobile_files, u.email_issues, u.mobile_issues, u.email_msgs, u.mobile_msgs, u.email_mstones, u.mobile_mstones, u.email_todos, u.mobile_todos, c.carrier,c.prefix,c.suffix FROM #variables.tableprefix#message_notify m LEFT JOIN #variables.tableprefix#users u ON m.userID = u.userID LEFT JOIN #variables.tableprefix#carriers c ON u.carrierID = c.carrierID WHERE m.projectID = AND m.messageID = SELECT distinct ms.milestoneid, ms.name FROM #variables.tableprefix#messages m LEFT JOIN #variables.tableprefix#milestones ms ON m.milestoneid = ms.milestoneid WHERE m.projectID = AND ms.name != '' SELECT distinct month(stamp) as m, year(stamp) as y FROM #variables.tableprefix#messages WHERE projectID = INSERT INTO #variables.tableprefix#messages (messageID,projectID,title,message,categoryID,milestoneID,allowcomments,userID,stamp) VALUES (, , , , , , , , #Now()#) UPDATE #variables.tableprefix#messages SET title = , message = , categoryid = , milestoneid = , allowcomments = WHERE projectid = AND messageid = The message entitled #arguments.title# has been updated: To view the full message and leave comments, visit this link: #application.settings.rootURL##application.settings.mapping#/message.cfm?p=#arguments.projectID#&m=#arguments.messageID# #theMessage# #theMessage# DELETE FROM #variables.tableprefix#messages WHERE messageID = AND projectID = DELETE FROM #variables.tableprefix#comments WHERE itemID = AND projectID = DELETE FROM #variables.tableprefix#message_notify WHERE messageID = AND projectID = DELETE FROM #variables.tableprefix#file_attach WHERE itemID = AND type = 'msg' INSERT INTO #variables.tableprefix#message_notify (messageID,projectID,userID) VALUES (, , ) SELECT u.userID,u.email FROM #variables.tableprefix#message_notify mn LEFT JOIN #variables.tableprefix#users u ON mn.userID = u.userID WHERE messageID = AND projectID = DELETE FROM #variables.tableprefix#message_notify WHERE messageID = AND projectID = AND userID = SELECT c.categoryID, c.category, count(m.messageID) as numMsgs FROM #variables.tableprefix#categories c LEFT JOIN #variables.tableprefix#messages m ON c.categoryID = m.categoryID WHERE c.projectID = AND c.type = 'msg' GROUP BY c.categoryID, c.category ORDER BY c.category