<%@ page language="java" import="java.sql.*, java.io.*, java.util.*, users.databases.*" errorPage="error.jsp" %> <% /***** VARIABLE DECLARATION and INITIALIZATION *****/ String strMainDB = "product_pgpClientInfoDB"; String strCompanyName = "", strDeleteMsg = ""; int intUserID = Integer.parseInt(request.getParameter("uid")); int intCompanyID = Integer.parseInt(request.getParameter("cid")); byte bytBtnID = Byte.parseByte(request.getParameter("did")); String [] arrCPID = request.getParameterValues("id"); String [] arrCPName = new String [arrCPID.length]; String [] arrCPPos = new String [arrCPID.length]; /***** END OF VARIABLE DECLARATION *****/ String SQLstmt = "SELECT LogOnStatus FROM tblLogOn WHERE Usr_ID=" + intUserID + ";"; users.connect(strMainDB); ResultSet rs = users.listQuery(SQLstmt); byte bytLogStatus = 0; while (rs.next()) { bytLogStatus = rs.getByte("LogOnStatus"); } if (bytLogStatus != 1) { // LOG CHECK RESULT - LOG-OUT, DISPLAYS HOME PAGE %> <% } else { // LOG CHECK RESULT - LOG-ON, PROCEED DISPLAYING ACTUAL PAGE SQLstmt = "SELECT Co_Name FROM tblCompanyInfo WHERE Co_ID=" + intCompanyID + ";"; rs = users.listQuery(SQLstmt); while (rs.next()) { // GET NAME OF COMPANY strCompanyName = rs.getString("Co_Name"); } SQLstmt = "SELECT CPx_ID, CPx_FirstN, CPx_LastN, CPx_Position FROM tblOtherCPs" + " WHERE Co_ID=" + intCompanyID + " ORDER BY CPx_ID;"; rs = users.listQuery(SQLstmt); int ctr = 0; while (rs.next()) { for (int i=0; i Summary - Delete Contact Persons


<%= strDeleteMsg %>

<% for (int i=0; i <% } else { // DISPLAY CONTACT PERSONS TO BE DELETED %> - Name: <%= arrCPName[i] %>, Position: <%= arrCPPos[i] %>
<% } } %>


<% if (ctr>=1) { %> Would you like to proceed? <% } %>

<% } %>