SELECT #getQueryString()# WHERE employeeAccessProfile.idEmployee= AND employeeAccessProfile.idProject= IS NULL SELECT DISTINCT #getQueryString()# WHERE employeeAccessProfile.idEmployee= AND employeeAccessProfile.idProject= ORDER BY #arguments.orderBy##module.list.orderBy# SELECT DISTINCT #getQueryString()# WHERE employeeAccessProfile.idEmployee= AND employeeAccessProfile.idProject IS NOT NULL ORDER BY #arguments.orderBy##module.list.orderBy# SELECT DISTINCT #getQueryString()# WHERE employeeAccessProfile.idAccessProfile= AND employeeAccessProfile.idProject= ORDER BY #arguments.orderBy##module.list.orderBy# SELECT employeeAccessProfile.idAccessProfile, accessProfileRoles.idSystemModule, accessProfileRoles.roles, systemModule.idParent, systemModule.location, systemModule.displayName FROM employeeAccessProfile LEFT JOIN accessProfileRoles ON employeeAccessProfile.idAccessProfile=accessProfileRoles.idAccessProfile LEFT JOIN systemModule ON systemModule.idSystemModule=accessProfileRoles.idSystemModule WHERE employeeAccessProfile.idEmployee= AND employeeAccessProfile.idProject IS NULL AND systemModule.idParent= AND systemModule.showInMenu= ORDER BY systemModule.idParent, accessProfileRoles.idSystemModule INSERT INTO employeeAccessProfile ( idEmployee, idAccessProfile, idProject ) VALUES ( , , NULL ) ON DUPLICATE KEY UPDATE idAccessProfile= Details: " & cfcatch.Detail> DELETE FROM employeeAccessProfile WHERE employeeAccessProfile.idEmployee= AND employeeAccessProfile.idProject= IS NULL Details: " & cfcatch.Detail> SELECT DISTINCT employeeAccessProfile.idEmployee, employee.nameFirst, employee.nameFirst1, employee.nameLast, employee.nameLast1 FROM employeeAccessProfile LEFT JOIN employee ON employeeAccessProfile.idEmployee=employee.idEmployee LEFT JOIN accessProfile ON employeeAccessProfile.idAccessProfile=accessProfile.idAccessProfile AND accessProfile.name LIKE WHERE 1=1 AND employeeAccessProfile.idProject= AND accessProfile.name LIKE ORDER BY employee.nameFirst, employee.nameFirst1, employee.nameLast, employee.nameLast1 #list.project# #name#