insert into lh_attachments(id, issueidfk, attachment, filename) values( , , , ) select filename from lh_attachments where issueidfk = and id = delete from lh_attachments where issueidfk = and id = select filename from lh_attachments where issueidfk = delete from lh_attachments where issueidfk = Lighthouse Pro Notification ============================================ Project: #project.getname()# Issue: #issueBean.getPublicID()#) #issueBean.getName()# (was #arguments.oldBean.getName()#) Project Area: #locus.getName()##locus# (was #oldLocus.getName()#) Milestone: #milestone# (was #oldmilestone#) Severity: #severity# (was #oldseverity#) Status: #status# (was #oldstatus#) Due Date: #dateFormat(issueBean.getDueDate(), "m/d/yy")# was #dateFormat(oldduedate, "m/d/yy")# Type: #issuetype# (was #oldissuetype#) Related URL: #issueBean.getRelatedURL()# Creator: #creator.getName()# Created: #dateFormat(issueBean.getCreated(),"m/d/yy")# #timeFormat(issueBean.getCreated(),"h:mm tt")# Updated:#dateFormat(issueBean.getUpdated(),"m/d/yy")# #timeFormat(issueBean.getUpdated(),"h:mm tt")# Owner: #user.getName()# (was #oldUser.getName()#) Description: #issueBean.getDescription()# History: #issueBean.getHistory()# Link: #link# Log into Lighthouse to update issue This email was generated by Lighthouse Pro, an open-source ColdFusion bug tracker application created by Raymond Camden. Find more information at the Lighthouse Pro web site: http://ray.camdenfamily.com/projects/lhp Lighthouse Pro Notification

Lighthouse Pro Notification

Project:: #project.getname()#
Issue:: #issueBean.getPublicID()#) #issueBean.getName()# (was #arguments.oldBean.getName()#)
Project Area:: #locus.getName()##locus# (was #oldLocus.getName()#)
Milestone:: #milestone# (was #oldmilestone#)
Severity:: #severity# (was #oldseverity#)
Status:: #status# (was #oldstatus#)
Due Date:: #dateFormat(issueBean.getDueDate(), "m/d/yy")# was #dateFormat(oldduedate, "m/d/yy")#
Type:: #issuetype# (was #oldissuetype#)
Related URL:: #issueBean.getRelatedURL()#
Creator:: #creator.getName()#
Created:: #dateFormat(issueBean.getCreated(),"m/d/yy")# #timeFormat(issueBean.getCreated(),"h:mm tt")#
Updated:: #dateFormat(issueBean.getUpdated(),"m/d/yy")# #timeFormat(issueBean.getUpdated(),"h:mm tt")#
Owner:: #user.getName()# (was #oldUser.getName()#)
Description:: #variables.utils.paragraphFormat2(htmlEditFormat(issueBean.getDescription()))#
History:: #variables.utils.paragraphFormat2(htmlEditFormat(issueBean.getHistory()))#
Link:: Log into Lighthouse to update issue

This email was generated by Lighthouse Pro, an open-source ColdFusion bug tracker application created by Raymond Camden. Find more information at the Lighthouse Pro web site: http://ray.camdenfamily.com/projects/lhp

#textmailbody# #HTMLmailbody# #textmailbody# #HTMLmailbody# select id, issueidfk, attachment, filename from lh_attachments where issueidfk = SELECT i.id, i.projectidfk, i.created, i.updated, i.publicid, i.duedate, i.name, i.useridfk, i.description, i.history, i.creatoridfk, i.locusidfk, i.severityidfk, i.statusidfk, i.relatedurl, i.milestoneidfk, pl.name AS locusname, sev.name AS severityname, st.name AS statusname, st.rank as statusrank, p.name AS projectname, sev.rank AS severityrank, u.name AS username, it.name as issuetype, m.name as milestone, i.issuetypeidfk FROM ((((((lh_issues AS i LEFT JOIN lh_projectloci AS pl on i.locusidfk = pl.id) LEFT JOIN lh_severities AS sev on i.severityidfk = sev.id) LEFT JOIN lh_statuses AS st on i.statusidfk = st.id) LEFT JOIN lh_projects AS p on i.projectidfk = p.id) LEFT JOIN lh_users AS u on i.useridfk = u.id) LEFT JOIN lh_issuetypes AS it on i.issuetypeidfk = it.id) LEFT JOIN lh_milestones AS m on i.milestoneidfk = m.id WHERE 1=1 AND i.projectidfk = AND i.projectidfk IN () AND i.useridfk = AND i.issuetypeidfk = AND i.locusidfk = AND i.severityidfk = AND i.statusidfk = AND i.useridfk = AND i.milestoneidfk = and ( i.name like or i.description like or i.publicid = ) ORDER BY #arguments.sort# #arguments.sortdir# ","ALL")>

Name: #arguments.i.getName()#

ID: #arguments.i.getPublicID()#

Project: #p.getName()#

Type: #variables.issuetypeDAO.read(arguments.i.getIssueTypeIDFK()).getName()#

Project Area: #locus.getName()#

Severity: #variables.severityDAO.read(arguments.i.getSeverityIDFK()).getName()#

Status: #variables.statusDAO.read(arguments.i.getStatusIDFK()).getName()#

Due Date: #dateFormat(arguments.i.getDueDate(),"mm/dd/yy")# #timeFormat(arguments.i.getDueDate(),"h:mm tt")#

Milestone: #variables.milestoneDAO.read(arguments.i.getMilestoneIDFK()).getName()#

Related URL: #arguments.i.getRelatedURL()#

Owner: #user.getName()# (#user.getUsername()#)

Creator: #creator.getName()# (#creator.getUsername()#)

Created: #dateFormat(arguments.i.getCreated(),"mm/dd/yy")# #timeFormat(arguments.i.getCreated(),"h:mm tt")#

Last Updated: #dateFormat(arguments.i.getUpdated(),"mm/dd/yy")# #timeFormat(arguments.i.getUpdated(),"h:mm tt")#

Description:
#paragraphFormat(arguments.i.getDescription())#

History:
#paragraphFormat2(arguments.i.getHistory())#

Name:	#arguments.i.getName()#
ID:	#arguments.i.getPublicID()#
Project:	#p.getName()#
Type:	#variables.issuetypeDAO.read(arguments.i.getIssueTypeIDFK()).getName()#
Project Area:	#locus.getName()#
Severity:	#variables.severityDAO.read(arguments.i.getSeverityIDFK()).getName()#
Status:	#variables.statusDAO.read(arguments.i.getStatusIDFK()).getName()#
Due Date:	#dateFormat(arguments.i.getDueDate(),"mm/dd/yy")# #timeFormat(arguments.i.getDueDate(),"h:mm tt")#
Milestone:	#variables.milestoneDAO.read(arguments.i.getMilestoneIDFK()).getName()#
Related URL:	#arguments.i.getRelatedURL()#
Owner:	#user.getName()# (#user.getUsername()#)
Creator:	#creator.getName()# (#creator.getUsername()#)
Created:	#dateFormat(arguments.i.getCreated(),"mm/dd/yy")# #timeFormat(arguments.i.getCreated(),"h:mm tt")#
Last Updated:	#dateFormat(arguments.i.getUpdated(),"mm/dd/yy")# #timeFormat(arguments.i.getUpdated(),"h:mm tt")#

Description: #paragraphFormat(arguments.i.getDescription())#

History: #paragraphFormat2(arguments.i.getHistory())#