SELECT #getQueryString()# WHERE project.idProject= SELECT DISTINCT employeeAccessProfile.idEmployee, CONCAT(TRIM(employee.nameFirst),' ', TRIM(employee.nameFirst1),' ',TRIM(employee.nameLast),' ',TRIM(employee.nameLast1)) as employee, employeeAccessProfile.idAccessProfile, accessProfile.name AS accessProfile, employeeAccessProfile.idProject, project.name as project FROM employeeAccessProfile LEFT JOIN employee ON employeeAccessProfile.idEmployee=employee.idEmployee LEFT JOIN accessProfile ON employeeAccessProfile.idAccessProfile=accessProfile.idAccessProfile LEFT JOIN project ON employeeAccessProfile.idProject=project.idProject WHERE employeeAccessProfile.idEmployee= AND employeeAccessProfile.idProject IS NOT NULL ORDER BY #arguments.orderBy##module.list.orderBy# #list.name# SELECT idProject FROM project WHERE name= AND idProject != INSERT INTO project ( idProject, name ) VALUES ( , ) Details: " & cfcatch.Detail> UPDATE project SET name= WHERE idProject= Details: " & cfcatch.Detail> DELETE FROM project WHERE idProject= Details: " & cfcatch.Detail>