"
SELECT * FROM projects
WHERE ProjectCode = "#Form.ProjectCode#"
SELECT * FROM participants
WHERE ProjectID = '#Client.ProjectID#' AND
LastName = '#Form.UserLastName#' AND
FirstName = '#Form.UserFirstName#'
UPDATE participants
SET VisitCount = VisitCount + 1
WHERE ID = '#ChkName.ID#'
INSERT INTO participants
(ID, ProjectID, AgentID,
FirstName, LastName, Email,
DateTaken, TimeTaken, VisitCount)
VALUES ('#Client.UserID#', '#GetProject.ID#', '#GetProject.AgentID#',
'#Form.UserFirstName#', '#Form.UserLastName#', '#Form.UserEmail#',
#CreateODBCDate(Now())#, #CreateODBCTime(Now())#, 1)
Update projects
SET UnitsUsed = UnitsUsed + 1
WHERE ID = '#GetProject.ID#'
SELECT * FROM participants
WHERE ProjectID = "#Client.ProjectID#" AND
LastName = "#Form.UserLastName#" AND FirstName = "#Form.UserFirstName#"
UPDATE participants
SET VisitCount = VisitCount + 1,
Email = '#Form.UserEmail#'
WHERE ID = '#GetUser.ID#'
H & A International - ICS-CONNECT Assessment