Contact Us: Staff Directory
<%
sSQL = "Select NEFPersonTitleList.Name as Title, departmentTypeList.Name as department, Person.LastName, Person.FirstName, PhoneNumber, emailaddress from Person " + _
" INNER JOIN NEFPersonTitleList on Person.NEFPersonTitleList_ID = NEFPersonTitleList.NEFPersonTitleList_ID " + _
" INNER JOIN departmentTypeList on person.departmentTypeList_ID = departmentTypeList.departmentTypeList_ID " + _
" LEFT JOIN PersonEmailAddress on Person.Person_ID = PersonEmailAddress.Person_ID " + _
" LEFT JOIN EmailAddress on EmailAddress.EmailAddress_ID = PersonEmailAddress.EmailAddress_ID " + _
" LEFT JOIN PersonPhysicalAddress on person.Person_ID = PersonPhysicalAddress.Person_ID " + _
" LEFT JOIN PhysicalAddress on PhysicalAddress.PhysicalAddress_ID = PersonPhysicalAddress.PhysicalAddress_ID " + _
" LEFT JOIN PersonPhoneNumber on Person.Person_ID = PersonPhoneNumber.person_ID " + _
" LEFT JOIN PhoneNumber on PhoneNumber.phoneNumber_ID = PersonPhoneNumber.PhoneNumber_ID " + _
" where legalEntity_ID =1 and PhoneNumberTypeList_ID = 1 and departmentTypeList.departmentTypeList_ID = " & request.Item("department")
if request.item("lastName") <> "" and request.item("firstName") <> "" then
sSQL2 = " and Person.lastName like ('" & request.item("lastName") & "') and person.firstNme like ('" & request.item("FirstName") & "')"
elseif request.item("lastName") <> "" then
sSQL2 = " and Person.lastName like ('" & request.item("lastName") & "')"
elseif request.item("firstName") <> "" then
sSQL2 = " and person.firstNme like ('" & request.item("FirstName") & "')"
end if
sSQL2 = sSQL2 & " order by LastName"
response.write sSQl & SSQl2
%>
